---
title: "PostgreSQL 11 released: A look at what's new"
publication: "Postgres Weekly"
issue: 279
published_at: "2018-10-24"
canonical_url: "https://postgresweekly.com/issues/279"
---

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

#279 — October 24, 2018 

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

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/selwciixerbd5unntgxb.jpg)](https://www.postgresql.org/about/news/1894/)  

[PostgreSQL 11 Released](https://www.postgresql.org/about/news/1894/) — This long awaited major release includes hash partitioning, covering indexes, transactions in stored procedures, [and more.](https://pgdash.io/blog/postgres-11-whats-new.html) 

PostgreSQL Global Development Group   

[New in Postgres 11: Monitoring JIT Performance, Auto Prewarm and Stored Procedures](https://pganalyze.com/blog/postgres11-jit-compilation-auto-prewarm-sql-stored-procedures) — Postgres 11 features some great improvements and on in particular JIT compilation can have some great performance improvements. Get a look at exactly what it can mean for performance. 

Luka Fittl   [![\](https://copm.s3.amazonaws.com/c9e3d9ee.png)](https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog) 

[SQL Functions in Postgres, From the Devs at Citus Data](https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog) — If you can dream it, there’s a SQL function for it in Postgres. A sampling of the hundreds of built-in SQL functions, including favorites like array_agg, array_to_string, now, allballs, data_trunc, and JSONB operators. 

CITUS DATA sponsor   

[PostgreSQL 11: A First Take on the New Release](https://www.percona.com/blog/2018/10/18/postgresql-11-our-first-take-on-the-new-release/) — Thoughts on some of the _“killer features”_ of the latest release. 

Jobin Augustine, Ibrar Ahmed, Avinash Vallarapu and Fernando Laudares Camargos   

[A Look at Parallelism in Postgres 11](https://speakerdeck.com/macdice/parallelism-in-postgresql-11) — Postgres got initial support for parallelism a couple of releases ago. That doesn’t mean everything is parallelized (yet). This talk from PostgresOpen Silicon Valley a couple of weeks ago digs into whats new with parallelism in Postgres. 

Thomas Munro   

[Adding New Table Columns with Default Values in Postgres 11](https://blog.2ndquadrant.com/add-new-table-column-default-value-postgresql-11/) — In Postgres 11, adding a new column to a table with a default value is much faster as that default value is no longer written to every single existing row. 

Andrew Dunstan   

[Sharding Your Data with Postgres 11](https://pgdash.io/blog/postgres-11-sharding.html) — Postgres 10 added declarative table partitioning but in Postgres 11 you can now combine this with foreign data wrappers, providing a mechanism to natively shard tables across multiple servers. 

RapidLoop   

[How to Minimize RPO for Your Postgres Databases Using Point in Time Recovery](https://severalnines.com/blog/how-minimize-rpo-your-postgresql-databases-using-point-time-recovery) — ‘RPO’ (Recovery Point Objective) is a value in a disaster recovery plan that defines how much data you can ‘afford’ to lose and helps determine the design of your backup system. 

Severalnines   

[Commenting Your Postgres Database](https://www.citusdata.com/blog/2018/10/17/commenting-your-postgresql-database/) — Comments help when making your application code readable, but they can also be a powerful tool when it comes to documenting your queries and schemas. 

Craig Kerstiens   

[A Focus on Partitioning Improvements in Postgres 11](https://blog.2ndquadrant.com/partitioning-improvements-pg11/) 

Alvaro Herrera   

[Monitoring Your PostgreSQL Database with Telegraf and InfluxDB](https://www.influxdata.com/blog/monitoring-your-postgresql-database-with-telegraf-and-influxdb/) 

InfluxData sponsor   

[Building an Enterprise-Grade Postgres Setup Using Open Source Tools](https://www.percona.com/blog/2018/10/19/postgresql-building-enterprise-grade-setup-with-open-source/) — You can watch a replay of Percona’s recent webinar [here](https://www.percona.com/resources/webinars/enterprise-grade-postgresql-built-open-source-tools), or read this article for the key questions and answers that cropped up. 

Jobin Augustine   

[Pgpool-II 4.0 Released](http://pgsqlpgpool.blogspot.com/2018/10/pgpool-ii-40-released-scram.html) — Pgpool is a popular connection pooling middleware and it now supports SCRAM authentication too. 

Tatsuo Ishii  

🗓 Events  

[PostgreSQL is Not Your Traditional SQL Database](https://register.gotowebinar.com/register/3930869911246887681?source=lp) — **October 30 (Webinar)** Gülçin Yıldırım Jelínek will cover design choices in PostgreSQL, full text search in PostgreSQL and more.   

[PGDay.Seoul 2018](http://pgday.postgresql.kr) — **November 3 (Seoul, South Korea)** PostgreSQL Korean Users group prepared the third half day event. All presentations are in Korean.   

[Pg Down Under 2018](https://2018.pgdu.org/) — **December 7 (Melbourne, Australia)** PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.   

[PGConf.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **December 10-12 (Tokyo, Japan)** The largest PostgreSQL event in Asia.         

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