#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.