---
title: "The Major Features in Postgres 11"
publication: "Postgres Weekly"
issue: 274
published_at: "2018-09-19"
canonical_url: "https://postgresweekly.com/issues/274"
---

The latest Postgres news, articles, tools, and projects.       

#274 — September 19, 2018 

[Read on the Web](https://postgresweekly.com/issues/274)   

Postgres Weekly  

[The Major Features in Postgres 11](http://momjian.us/main/writings/pgsql/features.pdf)– 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](https://blog.timescale.com/announcing-1-0-enterprise-ready-time-series-database-sql-open-source-400b4342dfa0) — 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   [![\](https://copm.s3.amazonaws.com/70271d1e.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) 

[Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) — 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](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP). 

Datadog sponsor   

[Why Covering Indexes Will Be Incredibly Helpful](https://info.crunchydata.com/blog/why-covering-indexes-are-incredibly-helpful) — A practical demonstration of the benefits of covering indexes, a [new feature to Postgres 11](https://paquier.xyz/postgresql-2/postgres-11-covering-indexes/) 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](https://medium.com/@hakibenita/be-careful-with-cte-in-postgresql-fca5e24d2119) — 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](https://www.percona.com/blog/2018/08/24/postgresql-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](https://momjian.us/main/blogs/pgblog/2018.html#September_12_2018) 

Bruce Momjian   

[Linux Kernel Parameters You Can Tune to Optimize Postgres](https://www.percona.com/blog/2018/08/29/tune-linux-kernel-parameters-for-postgresql-optimization/) 

Ibrar Ahmed   

[Upgrading Postgres on AWS RDS with Minimum or Zero Downtime](https://medium.com/preply-engineering/postgres-multimaster-34f2446d5e14) — 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’](https://t.co/WOLRgg6C0t) 

EnterpriseDB sponsor   

[PostGIS 2.5.0 Release Candidate 2 Released](http://postgis.net/2018/09/16/postgis-2.5.0rc2/) — Best served with PostgreSQL 11beta3. 

PostGIS Developers  

Events  

[PostgresConf South Africa 2018](https://postgresconf.org/conferences/SouthAfrica2018) — **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](https://www.pgconf.asia/EN/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](https://2019.fosdempgday.org/) — **February 1, 2019 (Brussels, Belgium)** An extension to the regular PostgreSQL activities at FOSDEM.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom