Postgres Weekly

#274 — September 19, 2018

Read on the Web

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.

Issue 273 #274 Issue 275