#274 — September 19, 2018 |
Postgres Weekly |
The Major Features in Postgres 11 – PDF — Bruce has updated his popular slidedeck for Postgres 10 to now focus on Postgres 11’s feature-set. Bruce Momjian |
TimescaleDB 1.0: A Time-Series Extension to Postgres — First launched 18 months ago, Timescale is a database built as an extension to Postgres that’s now in used in numerous large scale deployments for time-series work. Ajay Kulkarni |
Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom PostgreSQL metrics and correlate them with data from your distributed infrastructure, applications, and logs. Gain real-time performance insights and set intelligent alerts with Datadog. Start a free trial. Datadog sponsor |
Why Covering Indexes Will Be Incredibly Helpful — A practical demonstration of the benefits of covering indexes, a new feature to Postgres 11 that let you include certain types of extra data in an index to speed up lookups. Jonathan S. Katz |
Be Careful with CTEs in Postgres — Common table expressions (CTE) can come in very handy but when used incorrectly they could cause a significant performance hit. Haki Benita |
Accessing MySQL as a Data Source using mysql_fdw — If you have both Postgres and MySQL in your organization, this foreign data wrapper could help you bring them together. Jobin Augustine |
Using pg_dump in a Multi-Host Scenario Bruce Momjian |
Linux Kernel Parameters You Can Tune to Optimize Postgres Ibrar Ahmed |
Upgrading Postgres on AWS RDS with Minimum or Zero Downtime — A DevOps engineer shares details on upgrading databases on Amazon Cloud, why they ended up using Bucardo for asynchronous multi-master replication and how they upgraded their production database without downtime. Amet Umerov |
New On The Blog: ‘Comparing The EDB Postgres Platform & PostgreSQL’ EnterpriseDB sponsor |
PostGIS 2.5.0 Release Candidate 2 Released — Best served with PostgreSQL 11beta3. PostGIS Developers |
Events |
PostgresConf South Africa 2018 — October 9-10 (Johannesburg, South Africa) An opportunity for the database administration and developer community to exchange ideas and learn about current features and upcoming trends.
|
PGCONF.ASIA 2018 — Decemeber 10-12 (Tokyo, Japan) PGConf.ASIA 2018 is an international conference for PostgreSQL. Come and join this one of the largest PostgreSQL conference held in Asia.
|
FOSDEM PGDay 2019 — February 1, 2019 (Brussels, Belgium) An extension to the regular PostgreSQL activities at FOSDEM. |