原文: Postgres Weekly Issue 299: April 3, 2019

...

It's always great to see Postgres gaining support for an SQL-standard feature and this commit begins with a simple example of how one type of generated column will work in the future. MySQL 5.7 introduced a similar feature and SQL Server calls them computed columns.

Last time they looked at using pg_dumpall, now it’s pg_dump and pg_restore’s turn under the spotlight.

There are several key metrics you’ll want to keep track of when it comes to database performance, and they’re not all database-specific.

(是也乎:

...

这种很搭的赞助商才对味儿

)

A multi-cloud DBaaS provider surveyed users at last month’s PostgresConf and shares the results here. AWS comes in as the most popular cloud platform to host Postgres on and cost is the biggest reason to choose Postgres.

In Postgres 12, the REINDEX command (which rebuilds an index from a table’s current data) gains an option to have it build the index in the background and switch it into play upon completion.

A new partnership with Timescale that introduces support for TimescaleDB (a Postgres extension that focuses on time-series support) on Azure for customers building IoT and time-series workloads.

Written in Python and can be used from your own Python scripts or the command line.

(是也乎:

哈, Python 喜欢干的事儿...

)

Active Record, as commonly used in Ruby on Rails apps to interact with databases, is naturally database agnostic but Postgres has so many extra querying features it’s a shame not to be able to use them. This gem adds things like array and JSON querying, CTEs, and unions to the mix.

A popular tool for replication and failover management that includes several usability improvements in this release.

社区/活动

🗓 Upcoming Postgres Events

The latest edition of the highly successful German-speaking PostgreSQL conference.

An annual conference for users and developers to meet and discuss all things Postgres.

是也乎

  • 190404 Zoom.Quiet 用时 13 分钟 完成快译.
  • 190404 Zoom.Quiet 用时 3 分钟 完成格式转抄.

Comments