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

Postgres Weekly 107   . 

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

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

[PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 Released](http://www.postgresql.org/about/news/1587/?utm_source=postgresweekly&utm_medium=email)All actively supported versions of Postgres just got a minor version release with some critical fixes for data corruption. If you haven’t already you should make sure to upgrade. postgresql.​org [Postgres Pushes Past MySQL in Developers' Hearts](http://www.techrepublic.com/article/postgres-pushes-past-mysql-in-developer-hearts/?utm_source=postgresweekly&utm_medium=email)It might not be news to us as Postgres has long been a trusted database for our data, but due to its continuing growth in features and usability Postgres is starting to surpass MySQL as the preferred database by ‘the kids’ according to this editorial. TechRepublic [The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4](http://blog.2ndquadrant.com/the-within-group-and-filter-sql-clauses-of-postgresql-9-4/?utm_source=postgresweekly&utm_medium=email)Sometimes complex orderings then calculations over data can be a bit complicated in SQL. Postgres 9.4 quietly brought a few new functions that make it more powerful and easier to iterate over groups of data for things like percentiles and more. 2nd Quadrant [Empowering Real-Time Big Data Using PostgreSQL](https://www.citusdata.com/citus-products/products-overview?utm_source=postgresweekly&utm_medium=email)Citus Data provides open source and commercial solutions for scaling out PostgreSQL to empower real-time big data. [View webinars](https://www.citusdata.com/resources/webinars) on topics such as scaling out and fast analytics for big datasets. Read our new [case study](https://www.citusdata.com/applications/mixrank-case-study) on solutions using PostgreSQL for real-time big data at MixRank. Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/83a3ce7d.png)](https://www.citusdata.com/citus-products/products-overview?utm_source=postgresweekly&utm_medium=email) [PLV8 now has JSONB support](https://github.com/plv8/plv8/commit/2e0914433a967a1a915a11b5c140843969eec5ad?utm_source=postgresweekly&utm_medium=email)PLV8, which lets you use the JavaScript V8 engine directly in Postgres, now has support for the JSONB datatype. This should allow you to take advantage of the latest JSON datatype along with full flexibility and power of JavaScript. plv8#code [PostGIS 2.2 Leveraging Power of PostgreSQL 9.5](http://www.postgresonline.com/journal/archives/350-PostGIS-2.2-leveraging-power-of-PostgreSQL-9.5.html?utm_source=postgresweekly&utm_medium=email)PostGIS, the best option for geospatial data, is under active development and a new version is coming. Feature freeze is planned for a few months from now and they’re expecting release this fall to be in line with Postgres 9.5. Take a look at some of the upcoming planned and committed features. Leo Hsu and Regina Obe [Think Twice, Join Once: Distinct On in PostgreSQL](http://www.noelherrick.com/blog/postgres-distinct-on?utm_source=postgresweekly&utm_medium=email) Noel Herrick#tutorial [SQL MERGE Is Quite Distinct From UPSERT](http://www.postgresql.org/message-id/CAM3SWZRP0c3g6+aJ=YYDGYAcTZg0xA8-1_FCVo5Xm7hrEL34kw@mail.gmail.com?utm_source=postgresweekly&utm_medium=email)Why is Postgres pursuing a non-standard variant of UPSERT rather than SQL’s MERGE? A developer explains why: they’re quite different things. Peter Geoghegan#opinion [Skytools: PgQ Queues and applications](http://www.slideshare.net/adorepump/skytools-pgq-queues-and-applications?utm_source=postgresweekly&utm_medium=email)Following up from a post last week on the issues with Postgres as a queue, here’s an older talk about PgQ from Skype and how it works and met their needs. Slideshare [Why Auto Increment Is A Terrible Idea](https://www.clever-cloud.com/blog/engineering/2015/05/20/Why-Auto-Increment-Is-A-Terrible-Idea/?utm_source=postgresweekly&utm_medium=email) Clément Delafargue#opinion    

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