---
title: "Postgres 9.6 has just been released"
publication: "Postgres Weekly"
issue: 176
published_at: "2016-09-29"
canonical_url: "https://postgresweekly.com/issues/176"
---

Postgres Weekly 176   . 

[Read this on the Web](http://postgresweekly.com/issues/176) 

[Postgres Weekly](http://postgresweekly.com) Issue 176 — September 29, 2016      

Don't adjust your sets - Postgres Weekly is out a day later than usual because the noteworthy 9.6 release was due today :-) 

[Postgres 9.6 Released](https://www.postgresql.org/about/news/1703/?utm_source=postgresweekly&utm_medium=email)The next key release of Postgres is here and ready to roll. Key features include parallel queries, faster autovacuum, phrase searching in full-text search, and many performance improvements. [Release notes here.](https://www.postgresql.org/docs/9.6/static/release-9-6.html) postgresql.​org 

[The Major Features in Postgres 9.6 [PDF\]](http://momjian.us/main/writings/pgsql/features.pdf?utm_source=postgresweekly&utm_medium=email)Straightforward, simple slides with the basics on 9.6’s new features. Bruce Momjian 

[pg_healer: Repair Postgres Problems Automatically](http://blog.endpoint.com/2016/09/pghealer-repairing-postgres-problems.html?utm_source=postgresweekly&utm_medium=email)Corruption is inevitable, and given a long enough timespan it can occur on many databases. pg_healer is a new extension that monitors for corruption and helps repair it. Greg Sabino Mullane#tools 

[A lightning-fast server for a powerful database.](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly/)Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code 'POSTGRES20'. Linode#sponsored — [![\](https://copm.s3.amazonaws.com/1eb3d9d3.png)](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly/) 

[Announcing Citus MX: Scaling Postgres to Over 500k Writes Per Second](https://www.citusdata.com/blog/2016/09/22/announcing-citus-mx/?utm_source=postgresweekly&utm_medium=email)The private beta of Citus MX is now available. Citus Data#news 

[PostgreSQL Replication Checklist](http://www.openscg.com/2016/09/postgresql-replication-checklist/?utm_source=postgresweekly&utm_medium=email)Postgres replication is a staple of any production installation, but there’s a number of options. This great guide from OpenSCG lays out the options and things you should think through as you decide which to use. David Rader 

[PGLiveBackup Beta 1: A bash-Based Postgres Backup and Restore Tool](https://www.postgresql.org/about/news/1697/?utm_source=postgresweekly&utm_medium=email) postgresql.​org#tools 

[PostGIS 2.3.0 Released](http://postgis.net/2016/09/26/postgis-2.3.0/?utm_source=postgresweekly&utm_medium=email)PostGIS 2.3 is already here with support for Postgres 9.6. The best part is it already leverages possibly the best feature in 9.6: parallelism. If you’re using PostGIS consider giving it a try. PostGIS Developers#tools 

[Barman 2.0 Released: A Backup Manager for Postgres](http://blog.2ndquadrant.com/the-best-barman-ever/?utm_source=postgresweekly&utm_medium=email)An open-source administration tool for disaster recovery of PostgreSQL servers. Gabriele Bartolini#tools 

[pg-eyeballs: Use Postgres' 'EXPLAIN' Command from ActiveRecord](https://github.com/bradurani/pg-eyeballs/?utm_source=postgresweekly&utm_medium=email) Brad Urani#code 

[asyncpg: A Fast PostgreSQL Database Client Library for Python/asyncio](https://github.com/MagicStack/asyncpg/?utm_source=postgresweekly&utm_medium=email) magicstack#code 

[Publish Web Apps Based On Your PostgreSQL Database Fast](https://github.com/workflowproducts/envelope/?utm_source=postgresweekly&utm_medium=email)Envelope is designed to completely replace the middleware that sits between your web server and your PostgreSQL database. Workflow Products#code 

[Stop wasting time - know what you'll earn before the interview](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Hired.​com#job     

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/176) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK