Postgres Weekly : Issue 229 ~蠎周刊 ~汇集全球蠎事儿 ;-)

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

Postgres 获得 'Generated Column' 支持
- Peter Eisentraut

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.

用 pg_dump / pg_restore 进行 Postgres 升级
- Jobin Augustine, Vallarapu, et al.

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

在 PostgreSQL 数据库中监控的度量标准
- InfluxData
- sponsor

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.

(是也乎:

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

)

2019 年 PostgreSQL 趋势报告
- ScaleGrid

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.

就等 PostgreSQL 12: REINDEX CONCURRENTLY
- Hubert depesz Lubaczewski

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.

用 TimescaleDB 为 PostgreSQL 的 Azure 数据库就物联网和时间序列工作负载提供动力
- Sunil Kamath (Microsoft)

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.

如何将大规模并行 Postgres 数据库迁移进 Kubernetes
- Oz Basarir (Pivotal)
Pgpool-II 4.1 中的语句级负载平衡
- PgPool
Migra: Like diff But For Postgres Schemas
- Robert Lechte

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

(是也乎:

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

)

ActiveRecordExtended 1.0: Adds Additional Postgres Functionality to Ruby's Active Record
- George Protacio-Karaszi

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.