原文: 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



蟒营®编程思维提高班 Python版/第10期 正在报名

精品小班/ 每期<42人

  • 开始报名: 2020.6.29
  • 报名截止: 2020.7.20
  • 正式开课: 2020.7.26
  • 课程结束: 2020.9.06
101camp9py

蟒营®式 原创课程

伴你重享学习乐趣

py.101.camp

Reactivate Joy by Self-teching with You


任何问题可先进入知识星球(免费)咨询:
FAQ

关注公众号, 持续获得相关各种咨询:
mainium


追问

任何问题, 随时邮件提问可也:
askdama@googlegroups.com