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

Postgres Weekly 152   . 

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

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

[Postgres 9.5: New 'Group By' Options for Aggregation](https://compose.io/articles/deeper-into-postgres-9-5-new-group-by-options-for-aggregation/?utm_source=postgresweekly&utm_medium=email)A look at aggregating data for reports in 9.5 using GROUP BY and CUBE. Lisa Smith#code [What Does PostgreSQL 9.5 Bring to Developers](http://blog.nordeus.com/dev-ops/what-does-postgresql-9-5-bring-to-developers.htm?utm_source=postgresweekly&utm_medium=email)Postgres has had a number of releases that focus on underlying performance or where there’s just one landmark improvement. Postgres 9.5 was as end user focused as many, and here’s the rundown of its benefits. Nordeus Blog [Parallel Query Support: Does It Help for PostGIS Use?](http://blog.cleverelephant.ca/2016/03/parallel-postgis.html?utm_source=postgresweekly&utm_medium=email)Support for parallel queries has been at the top of our request list to the core team for a long time. Now that it is finally arriving in 9.6 the question is: does it really help? Paul Ramsey#opinion [Postgres Vision 2016 Conference: Future of Enterprise Postgres & Open Source DM](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016PGVisionPR)Postgres Vision focuses on current and future enterprise usage of Postgres. This event includes insights from technology and business luminaries, use cases, a look at the Postgres ecosystem, and long-range outlooks from analysts. Visit PostgresVision.com. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/19eebb61.png)](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016PGVisionPR) [PostgreSQL Query Optimization](http://jinchengli.me/post/postgres-query-opt/?utm_source=postgresweekly&utm_medium=email)For many, what happens when you join two tables is a mystery. Once you do build a deeper understanding, it becomes much easier to optimize joins - luckily it’s not rocket science to understand some of the logic under the covers, as seen here. Jincheng Li [Hashed Passwords with PostgreSQL's pgcrypto](http://www.meetspaceapp.com/2016/04/12/passwords-postgresql-pgcrypto.html?utm_source=postgresweekly&utm_medium=email)How to do password hashing with just PostgreSQL’s pgcrypto. Nick Gauthier#tutorial [Extensible Access Methods Are Committed to 9.6](http://akorotkov.github.io/blog/2016/04/06/extensible-access-methods/?utm_source=postgresweekly&utm_medium=email)A big change under the covers which won’t manifest to users, except in accelerated addition of new features. Extensible access methods continues the theme of Postgres as more of a platform than simply a RDMBS. Alexander Korotkov#code [An SQL Joins Visualizer](http://sql-joins.leopard.in.ua/?utm_source=postgresweekly&utm_medium=email)A simple, but very clear tool to visually explain joins in SQL. Alexey Vasiliev#tools [Data Modeling in Cassandra From A Postgres Perspective](http://neovintage.org/2016/04/07/data-modeling-in-cassandra-from-a-postgres-perspective/?utm_source=postgresweekly&utm_medium=email)We often feature articles about people moving from other systems to Postgres - in contrast, here’s how to apply a Postgres perspective to a database that doesn’t lend quite the same flexibility: Cassandra. neovintage.​org [PostgreSQL Health Check - Get your database checked by our experts](http://2ndquadrant.com/postgresql-healthcheck/)A comprehensive audit of your database architecture to improve performance, uptime, security and recoverability. 2ndQuadrant PostgreSQL Health Check#sponsored [PGConf US 2016 One Week Away - Registrations Closing](http://www.postgresql.org/about/news/1658/?utm_source=postgresweekly&utm_medium=email) postgresql.​org#news    

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