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

Postgres Weekly 154   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 154 — April 27, 2016     

[PostgreSQL 9.6 with Parallel Query vs. TPC-H](http://rhaas.blogspot.com/2016/04/postgresql-96-with-parallel-query-vs.html?utm_source=postgresweekly&utm_medium=email)TPC is a common benchmark for database performance. Here’s a look at how Postgres measures up, with in some cases a nice 5x performance gain. Robert Haas [What PostgreSQL Tells You About Its Performance](http://okigiveup.net/what-postgresql-tells-you-about-its-performance/?utm_source=postgresweekly&utm_medium=email)Postgres keeps a lot about performance under the covers, here’s a great dive into whats there and how to begin to take advantage of it. OK I GIVE UP [A Look at Postgres Index Types](https://robots.thoughtbot.com/postgres-index-types?utm_source=postgresweekly&utm_medium=email)Postgres has an index type for just about everything you could want. Here’s a great overview of types available and guidance around them. Thoughtbot [FREE Online Workshop: Monitoring Postgres using EDB Postgres Enterprise Manager](http://info.enterprisedb.com/20160510-Monitoring-Postgres-using-PEMWorkshop.html?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016APR_PEM)Learn how to use Postgres Enterprise Manager to effectively monitor and manage your Postgres database servers in this free, 4-hour online training session on Tuesday, May 10, 2016. Hurry - seats fill up fast! EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/c7479542.png)](http://info.enterprisedb.com/20160510-Monitoring-Postgres-using-PEMWorkshop.html?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016APR_PEM) [Waiting for 9.6 - Bloom Index Contrib Module](http://www.depesz.com/2016/04/11/waiting-for-9-6-bloom-index-contrib-module/?utm_source=postgresweekly&utm_medium=email)As highlighted in this issue, Postgres has a number of useful index types already, but that doesn’t mean we can’t use more. Bloom indexes are the latest to be added coming in 9.6 and in certain cases with indexing multiple columns can be incredibly handy. Hubert depesz Lubaczewski [Introducing Citus Cloud](https://www.citusdata.com/blog/1773-craig-kerstiens/414-introducing-citus-cloud?utm_source=postgresweekly&utm_medium=email)Citus, the extension that allows you to easily shard your data turning Postgres into a horizontally scalable distributed database, went [open source](https://www.citusdata.com/blog/17-ozgun-erdogan/403-citus-unforks-postgresql-goes-open-source) a few weeks ago, so now it’s available for anyone to use. This week brings Citus Cloud, an as-a-service offering making it simple to put in production and not have to manage yourself. Citus Data [Master-less Distributed Queue with Postgres and PG Paxos](https://www.citusdata.com/blog/14-marco/411-master-less-distributed-queue-postgres-and-pg-paxos?utm_source=postgresweekly&utm_medium=email)Pg_paxos is a database-level implementation of the widely renowned Paxos protocol. The defining feature of pg_paxos is that replication across the nodes of the cluster is always conflict-free. This in turn leads to a strictly consistent (as in the distributed sense of the C in CAP) view of the cluster. Citus Data [Row Level Security with PostgreSQL 9.5](https://www.compose.io/articles/row-level-security-with-postgresql-95/?utm_source=postgresweekly&utm_medium=email)Row level security, which landed in Postgres 9.5, allows you to not just secure an entire table, but specific rows within it. If you have some more specialized or stricter security needs of your database it may be part of the solution. Compose Articles [Postgres Adores a Vacuum](https://begriffs.com/posts/2016-04-19-postgres-adores-vacuum.html?utm_source=postgresweekly&utm_medium=email)Postgres under the covers is essentially an append-only log. This means it periodically needs to go in and clean up unused data either in rows or indexes, this excess and no longer used space is bloat. Postgres’ vacuum is your solution here for a healthy database. Joe 'begriffs' Nelson [On The Building Of A Postgres Cluster](https://speakerdeck.com/srihari/on-the-building-of-a-postgres-cluster?utm_source=postgresweekly&utm_medium=email)A deck presented at the recent RootConf. Srihari Sriraman [Postgres Container Access with a SQL Client](http://chrisstump.online/2016/04/06/postgres-container-access-sql-client/?utm_source=postgresweekly&utm_medium=email)Containers are great for local development, and often for deploying apps, but connecting into one can require more nuance than you might think. Here’s a crash course in simplifying it. Chris Stump [Hassle Free Monitoring and PostgreSQL Database Management](http://2ndquadrant.com/en/support/rdba/)Remote DBA combined with our 24/7 Production Support: monitoring, managing and a rapid fix for PostgreSQL database issues. 2ndQuadrant.​com#sponsored    

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