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

Postgres Weekly 155   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 155 — May 4, 2016     

[PostgreSQL Vacuuming: An Introduction for Busy Devs](http://okigiveup.net/postgresql-vacuuming-an-introduction-for-busy-devs/?utm_source=postgresweekly&utm_medium=email)Postgres’ vacuum often gets a bad rap for creating issues on your Postgres database. In reality, vacuum (and autovacuum) is busy working for you - learn more about what it is and how you can get along with it. OK I GIVE UP#tutorial [A Look at Other Postgres-Inspired Databases](http://bonesmoses.org/2016/04/29/pg-phriday-derivation-deluge/?utm_source=postgresweekly&utm_medium=email)A look at your options for scaling beyond Postgres using one of the many Postgres forks or ‘derivations’, ultimately letting you still maintain compatibility with Postgres. Shaun M.​ Thomas#opinion [mongo-query-to-postgres-jsonb: Converts MongoDB Queries to Postgresql Queries for JSONB Fields](https://github.com/thomas4019/mongo-query-to-postgres-jsonb?utm_source=postgresweekly&utm_medium=email)Looking to move directly from Mongo over to Postgres? This project could help by automatically converting your queries from Mongo to using JSONB. Thomas Hansen#code [PostgreSQL 9.5.2 Now on Compose](https://www.compose.io/articles/postgresql-9-5-now-on-compose/?utm_source=cooper&utm_medium=newsletter-postgres&utm_campaign=95-on-compose)Deploy Postgres 9.5.2 in minutes on Compose. Each deployment includes a 3-node HA cluster, auto-failover, auto-scaling and backups. Production-ready from the get-go with all the goodness of this recent release! Compose#sponsored[![\](https://copm.s3.amazonaws.com/48b73567.png)](https://www.compose.io/articles/postgresql-9-5-now-on-compose/?utm_source=cooper&utm_medium=newsletter-postgres&utm_campaign=95-on-compose) [PostgresOpen 2016: Call For Papers Open](http://www.postgresql.org/about/news/1663/?utm_source=postgresweekly&utm_medium=email)PostgresOpen is happening again this year in Dallas (Sep 13-16) and if you have something interesting to say about Postgres they’d love to hear it. postgresql.​org#news [Postgres 9.5 Now Default Version on Heroku](https://blog.heroku.com/archives/2016/5/3/postgres-95-general-availability?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 is now the new default version for all new Heroku Postgres databases. Heroku#news [Working with Email Addresses in PostgreSQL](https://hashrocket.com/blog/posts/working-with-email-addresses-in-postgresql?utm_source=postgresweekly&utm_medium=email)One common type of data in any app is the email address. Here are some tips for working with them in Postgres. Don’t forget the [pgemailaddr](https://github.com/petere/pgemailaddr) extension as well. Josh Branchaud#tutorial [Postgres Replication Catch-Up](https://postgresguy.wordpress.com/2016/04/20/postgres-replication-catch-up/?utm_source=postgresweekly&utm_medium=email)Postgres replication generally works well, but if you’re new to it there are a few things to watch out for. Here’s a look at one of the biggest things to be aware of: replication lag. Greig Wise#news [PGLogical 1.1 Released: Next Gen Replication](http://blog.2ndquadrant.com/pglogical-1-1/?utm_source=postgresweekly&utm_medium=email)A logical replication system implemented entirely as a PostgreSQL extension that requires no triggers or external programs. 2ndQuadrant#tools [pgcronjob: Run User-Defined DB Functions in A 'cron'-Like Fashion](https://github.com/trustly/pgcronjob?utm_source=postgresweekly&utm_medium=email)Useful for things like splitting large updates into multiple smaller transactions and sleep in between, or to run slow queries during non-peak hours. Trustly#code [PostGraphQL: A GraphQL Schema Created by Reflection Over A PostgreSQL Schema](https://github.com/calebmer/postgraphql?utm_source=postgresweekly&utm_medium=email) Caleb Meredith#code [Parallel PostGIS Joins](http://blog.cleverelephant.ca/2016/03/parallel-postgis-joins.html?utm_source=postgresweekly&utm_medium=email)Parallelism for some parts of queries in Postgres will be the highlight feature of Postgres 9.6. Here’s a look at what it will mean from a PostGIS perspective. Paul Ramsey#code [Remote DBA Support for PostgreSQL Database](http://2ndquadrant.com/en/support/rdba/)Difficulty managing your organization’s database? Remote DBA is the perfect solution to effective database management. 2ndQuadrant.​com#sponsored    

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