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

Postgres Weekly 106   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 106 — May 20, 2015     

[Postgres Job Queues and Failure By MVCC](https://brandur.org/postgres-queues?utm_source=postgresweekly&utm_medium=email)Postgres can provide great queue-like functionality for your application but sometimes the locking mechanisms required can create pain on production load systems. Brandur [PostgreSQL Conference Europe 2015 Call for Papers](http://www.postgresql.org/about/news/1584/?utm_source=postgresweekly&utm_medium=email)It’s going to be in Austria this October. postgresql.​org [Using PostgreSQL Explain](http://www.bitpop.in/blog/2015/5/2/explain-postgresql-explain?utm_source=postgresweekly&utm_medium=email)Every time a query is run, Postgres forms a ‘plan’ of how it will execute it. You can look at this plan with EXPLAIN - here’s a post that provides an overview of its use. Bitpop [The New Data Center Standard](http://info.enterprisedb.com/20150423-gartner-osdbms-report.html?src=2015gosdbms-pgw&utm_source=postgresweekly&utm_medium=email)A New Gartner report predicts open source databases will overtake proprietary solutions. By 2018, 70% of new apps will be deployed on OS databases with Postgres playing a huge role. Download the report. _(Registration Required.)_ EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/ad3fc157.jpg)](http://info.enterprisedb.com/20150423-gartner-osdbms-report.html?src=2015gosdbms-pgw&utm_source=postgresweekly&utm_medium=email) [Postgres Toolkit 0.2 Released](http://pgsnaga.blogspot.com/2015/05/postgres-toolkit.html?utm_source=postgresweekly&utm_medium=email)A collection of scripts and queries that any DBA should keep handy to help monitor and maintain a Postgres database. Satoshi Nagayasu [New JSONB Features for 9.5](http://adpgtech.blogspot.com/2015/05/new-jsonb-features-for-95.html?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 is coming and the final set of features are making their way in. Here’s the rundown of improvements to JSONB with a new awesome operator to concatenate two JSONB values. Andrew Dunstan [Announcing VividCortex's Free Network Analyzer Tools for MySQL and PostgreSQL](https://vividcortex.com/blog/2015/05/13/announcing-vividcortex-network-analyzer-mysql-postgresql/?utm_source=postgresweekly&utm_medium=email) VividCortex#tools [Waiting for 9.5 – Add Support for INSERT … ON CONFLICT DO NOTHING/UPDATE](http://www.depesz.com/2015/05/10/waiting-for-9-5-add-support-for-insert-on-conflict-do-nothingupdate/?utm_source=postgresweekly&utm_medium=email)Last week we looked at how ‘upsert’ functionality was finally landing in Postgres (in 9.5). This article takes another look at how it will work with an in-depth dive. Hubert depesz Lubaczewski [ERAlchemy: Entity Relation Diagrams Generation Tool](https://github.com/Alexis-benoist/eralchemy?utm_source=postgresweekly&utm_medium=email)Visualizing your data model can often provide some clarity as to how you’re interacting with it. ERAlchemy is a tool that makes generating Entity Relation Diagrams simple and easy. Alexis Benoist#code    

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