---
title: "This Week's PostgreSQL News (#179)"
publication: "Postgres Weekly"
issue: 179
published_at: "2016-10-19"
canonical_url: "https://postgresweekly.com/issues/179"
---

Postgres Weekly 179   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 179 — October 19, 2016     

[Postgres 9.6 Now in Beta on Heroku](https://devcenter.heroku.com/changelog-items/986?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 is here and it supports a number of new features, such as parallel sequential scans. It’s available in private beta on Heroku today. Heroku#news [Holy Easy PostgreSQL Deployment](http://www.openscg.com/2016/10/easy-postgresql-deployment-command-line/?utm_source=postgresweekly&utm_medium=email)Here’s a handy tool that makes it easier for you to install and manage not only Postgres, but many of the surrounding tools and extensions for it. David Rader [A Look at Logical Replication with pglogical](http://bonesmoses.org/2016/10/14/pg-phriday-perfectly-logical/?utm_source=postgresweekly&utm_medium=email)Logical replication has long been a missing feature in Postgres itself, but is available as an extension. Here’s a in-depth tour of the primary extension that makes it available today. Shaun M.​ Thomas [When it comes to PostgreSQL development, one company stands out.](http://blog.2ndquadrant.com/committed-to-postgresql-community-contributes-9-6/)At 2ndQuadrant we’re passionate about Open Source and PostgreSQL, investing significant resources into a continuous development program that every user can benefit from. Find out more about our recent contributions to PostgreSQL 9.6. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/3f504777.png)](http://blog.2ndquadrant.com/committed-to-postgresql-community-contributes-9-6/) [Loading Data into Postgres-XL At Over 9M Rows/Sec](http://blog.2ndquadrant.com/load-data-postgres-xl-9m-rows-sec/?utm_source=postgresweekly&utm_medium=email)Postgres-XL is a massively parallel database built on top of PostgreSQL 9.5 aimed at BI workloads. Pavan Deolasee [PGConf Silicon Valley - A Look at the Postgres Themes](https://www.citusdata.com/blog/2016/10/18/postgres-themes-at-pg-conf-sv/?utm_source=postgresweekly&utm_medium=email)PGConf Silicon Valley is just under a month away, and it features a great line-up of talks. Here’s a look at some of the key themes that are a part of this year’s line-up. Citus Data [BDR (Bi-Directional Replication) History and Future](http://blog.2ndquadrant.com/bdr-history-and-future/?utm_source=postgresweekly&utm_medium=email)BDR isn’t entirely new to Postgres; it has a long history of being implemented in add-ons and extensions. Craig Ringer [pgAudit: Auditing Database Operations, Part 2](http://info.crunchydata.com/blog/pgaudit-auditing-database-operations-part-2?utm_source=postgresweekly&utm_medium=email)A discussion of how to configure pgAudit to use an auditing role to watch only specific objects. This is helpful when managing or supporting PostgreSQL installations. Jason O'Donnell [pg_query_state: Live 'EXPLAIN' for Postgres Queries](https://github.com/postgrespro/pg_query_state?utm_source=postgresweekly&utm_medium=email) Postgres Professional#code [Want Multiple Job Offers? - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly. Hired#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/179) [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