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

Postgres Weekly 109   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 109 — June 10, 2015     

[PostgreSQL 9.4.3, 9.3.8, 9.2.12, 9.1.17 & 9.0.21 Released](http://www.postgresql.org/about/news/1590/?utm_source=postgresweekly&utm_medium=email)This release primarily fixes a startup failure problem created by the prior update release, and should be installed by all users who applied that release. Postgresql.​org [Porting ActiveRecord's 'Soft Delete' Behavior to Postgres](http://shuber.io/porting-activerecord-soft-delete-behavior-to-postgres/?utm_source=postgresweekly&utm_medium=email)The soft delete mechanism of some ORMs is incredibly valuable, it lets you actually retain your data while “deleting” a user or record. Sean Huber [SQLPro for Postgres: A Mac OS X Postgres Manager](http://www.hankinsoft.com/SQLProPostgres/?utm_source=postgresweekly&utm_medium=email)This beta is available for free. Hankinsoft Development#tools [Opbeat = Ops for developers](https://opbeat.com/blog/posts/auto-assignments/?utm_source=postgresweekly&utm_medium=email)New feature: Auto-assignments. When an error occurs, Opbeat deduces who the best equipped person to fix the code is, via Git. Receive fewer but smarter notifications spend more time being productive. [Read the full article.](https://opbeat.com/blog/posts/auto-assignments/?utm_source=postgresweekly&utm_medium=ad&utm_content=&utm_campaign=autoassign) Opbeat#sponsored[![\](http://s3.amazonaws.com/nlga/uploads/item/image/38426/t.png)](https://opbeat.com/blog/posts/auto-assignments/?utm_source=postgresweekly&utm_medium=email) [Moving past averages in Postgres with Percentiles](http://www.craigkerstiens.com/2015/06/07/Moving-past-averages-in-sql/?utm_source=postgresweekly&utm_medium=email)Averages are fairly straight forward to compute, but not always the best metric. Sometimes percentiles such as perc 90 or perc 95 are better indicators of how you’re actually doing, fortunately you can pretty easily get directly to those in SQL. Craig Kerstiens [Postgres UPSERT ON DUPLICATE and How Other Databases Implement UPSERT](http://michaelroders.tumblr.com/post/119356965581/postgres-upsert-on-duplicate-and-how-other?utm_source=postgresweekly&utm_medium=email)Want to see how Postgres’ upsert compares to other offerings? Here’s a rundown of the syntax vs. what other databases support. Micha Roders [Porting ActiveRecord Validations to Postgres](http://shuber.io/porting-activerecord-validations-to-postgres/?utm_source=postgresweekly&utm_medium=email)A look at how common ActiveRecord validations port to Postgres constraints in SQL. Sean Huber#tutorial [Goodbye jsonb_replace, Hello jsonb_set](http://adpgtech.blogspot.co.uk/2015/05/goodbye-jsonbreplace-hello-jsonbset.html?m=1&utm_source=postgresweekly&utm_medium=email)While a small change, a pretty critical one to the JSON operators for Postgres 9.5 this will easily let you update some value deep within a larger JSON object. Andrew Dunstan [CFP for PGConf Silicon Valley Closes June 15th](http://www.postgresql.org/about/news/1591/?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/109) [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