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

Postgres Weekly 138   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 138 — January 6, 2016     

[The FILTER Clause in Postgres 9.4](https://medium.com/little-programming-joys/the-filter-clause-in-postgres-9-4-3dd327d3c852?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 is a year old now, and while we’ve covered many features we’ve given no lip service to this one. The filter clause allows you to show how many results were omitted my some clause, which for validating data or otherwise can be very handy. Anderson Dias [UPSERT on Postgres 9.5](http://blog.andrebarbosa.co/upsert-on-postgres-9-5/?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 is due to land soon with a host of awesome [features](http://www.craigkerstiens.com/2015/12/27/postgres-9-5-feature-rundown/). The highlight will undoubtedly be 'upsert' - if you’re not familiar with it, this is a great primer. andrebarbosa.​co [What's New in PostgreSQL 9.5](https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.5?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 follows a recent trend of feature-packed releases for Postgres. Get the preview of what’s coming with the work in progress what’s new on the wiki, including: JSONB improvements, BRIN indexes, pg_rewind, and more. postgresql.​org [Comprehensive PostgreSQL Administration (Live Virtual Training)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=Jan2016CompLVT)This special 1-week course (Jan 11-15) combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration, with significant savings over list price. It is designed for database professionals who are responsible for administration and maintenance of PostgreSQL. Register now - use promo code COMB-WEB-161 to get an additional 20% off. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/24b964b5.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=Jan2016CompLVT) [From Postgres to Cassandra](http://neovintage.org/2015/12/29/from-postgres-to-cassandra/?utm_source=postgresweekly&utm_medium=email)Hopefully readers have no doubt that Postgres is a great option as a database, but sometimes Postgres outgrows a single node. At that point there’s a few options such as something like [pg_shard](https://www.citusdata.com/citus-products/pg-shard/pg-shard-quick-start-guide) or other data solutions such as Cassandra. This guide helps show where something like Cassandra might play in. Rimas Silkaitis [dbHero for PostgreSQL & MySQL](https://dbheroapp.com/gui-database-client-for-mysql-postgresql-mac-osx?utm_source=postgresweekly&utm_medium=email)The list of options seem to keep growing for GUI editors for Postgres. dbHero looks to be a simple and clean option that looks great for OSX users. dbHero [Is Bi-Directional Replication (BDR) in Postgres Transactional?](http://sdf.org/~riley/blog/2016/01/04/is-bi-directional-replication-bdr-in-postgres-transactional/?utm_source=postgresweekly&utm_medium=email)Bidirectional replication isn’t extremely common, but allows for potential multi-master setups with Postgres. Though as highlighted here, there’s a few new ways you need to approach transactional semantics as you do put it in place. Riley Berton [pome: A Postgres Metrics Dashboard Written in Go](https://github.com/rach/pome?utm_source=postgresweekly&utm_medium=email)If you’re running and managing your own Postgres instance chances are you want some dashboarding and tooling around it. If you don’t already have one setup or want to take a look at another pome is a simple but elegant dashboard for PG in Go. Rach Belaid#tools#code [pglogical: Next Generation Replication for Postgres](http://2ndquadrant.com/en/resources/pglogical/?utm_source=postgresweekly&utm_medium=email)The foundation for logical replication landed in Postgres 9.4, and now there’s a great solution to help you take advantage of it with plenty of supporting tooling. 2nd Quadrant#tools [Heroku Data Infrastructure Engineer](https://www.heroku.com/careers/104?utm_source=postgresweekly&utm_medium=email)Join the Heroku Data team and learn about supporting and operating database systems at scale. Heroku#job [Postgres Skills are in demand.](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres)Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today! Indeed#job    

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