--- title: "This Week's PostgreSQL News (#137)" publication: "Postgres Weekly" issue: 137 published_at: "2015-12-30" canonical_url: "https://postgresweekly.com/issues/137" --- Postgres Weekly 137 . [Read this on the Web](http://postgresweekly.com/issues/137) [Postgres Weekly](http://postgresweekly.com) Issue 137 — December 30, 2015 FROM THE EDITOR 2015 was another great year for Postgres. We saw the release of Postgres 9.4 which included the famed [JSONB](https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.4#JSONB_Binary_JSON_storage). Logical decoding also laid a great foundation for improving Postgres' replication story. We also saw an increase in tools and editors, including [Postico](https://itunes.apple.com/us/app/postico/id1031280567?ls=1=12), [SQL Pro](http://www.hankinsoft.com/SQLProPostgres/), and [DB Beaver](http://dbeaver.jkiss.org/). And finally we have [upsert committed in Postgres](http://www.craigkerstiens.com/2015/05/08/upsert-lands-in-postgres-9.5/), though we'll have to wait for the 9.5 release to have our hands on it. _Craig Kerstiens, Editor_ [My Top 10 Postgres Features and Tips for 2016](http://www.craigkerstiens.com/2015/12/29/my-postgres-top-10-for-2016/?utm_source=postgresweekly&utm_medium=email)If you’re looking for some reading and studying up for the new year, here’s a collection of my favorite Postgres features and tricks. You won’t need all of them all of the time, but when you do need them they can be handy to have in your toolbox. Craig Kerstiens [Postgres 9.5 - The Feature Rundown](http://www.craigkerstiens.com/2015/12/27/postgres-9-5-feature-rundown/?utm_source=postgresweekly&utm_medium=email)The Postgres 9.5 release candidate is out, and while yes we’re all excited about upsert in Postgres it does contain much more than that. If you’re curious what you have to look forward to with the new release give this a read. Craig Kerstiens [Scale Out Postgres for Real-Time Big Data Using CitusDB](http://info.citusdata.com/BigDataPW4.html?utm_source=postgresweekly&utm_medium=email)CitusDB delivers [real-time insights](http://info.citusdata.com/BigDataPW3.html) into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and [horizontally scales.](http://info.citusdata.com/BigDataPW3.html) Citus Data#sponsored — [![\](https://copm.s3.amazonaws.com/8aa06404.png)](http://info.citusdata.com/BigDataPW4.html?utm_source=postgresweekly&utm_medium=email) [A Christmas present: PostgreSQL 9.5 RC1](http://www.databasesoup.com/2015/12/a-christmas-present-postgresql-95-rc1.html?utm_source=postgresweekly&utm_medium=email)As we highlighted in this issue, Postgres 9.5 is getting close and has a lot of great features including upsert. If you want to get hands on with it, take a look at the release candidate, which is available now. databasesoup.​com [Waiting for 9.6: Allow EXPLAIN (ANALYZE, VERBOSE) to Display Per-Worker Statistics](http://www.depesz.com/2015/12/15/waiting-for-9-6-allow-explain-analyze-verbose-to-display-per-worker-statistics/?utm_source=postgresweekly&utm_medium=email)[Parallel scans](http://www.depesz.com/2015/11/17/waiting-for-9-6-generate-parallel-sequential-scan-plans-in-simple-cases/) already landed for Postgres 9.6 and should give some great performance gains. Now you can also get the insights into what each worker is doing when a parallel scan runs with EXPLAIN. Hubert depesz Lubaczewski [Is PostgreSQL Your Next JSON Database?](https://www.compose.io/articles/is-postgresql-your-next-json-database/?utm_source=postgresweekly&utm_medium=email)For those that haven’t been paying attention to JSON in Postgres and more recently JSONB in Postgres this post will catch you up on its history and how it now compares to other NoSQL solutions. compose.​io [Multi-dimensional Clustering Using K-Means in Postgres SQL](https://periscopedata.com/blog//multi-dimensional-clustering-using-k-means-postgres.html?utm_source=postgresweekly&utm_medium=email)K-means clustering can be an incredibly powerful way to [look at your data](http://www.craigkerstiens.com/2014/05/08/personas-data-science-k-means/), and you don’t have to boot up spark or load it into Python or R to run a k-means against your data. It can be done with SQL, albeit pretty gnarly SQL. periscopedata.​com [DataGrip 1.0: A new IDE for Databases and SQL](http://blog.jetbrains.com/datagrip/2015/12/16/datagrip-1-0-formerly-0xdbe-a-new-ide-for-dbs-and-sql/?utm_source=postgresweekly&utm_medium=email)Formerly 0xDBE, DataGrip is a new database-focused IDE from JetBrains (the creators of IntelliJ and WebStorm). It supports Oracle, SQL Server, DB2, Sybase, MySQL, Postgres, SQLite, Derby, HyperSQL and H2 out of the box. JetBrains#tools [pgcenter: top-Like PostgreSQL Statistics Viewer.](https://github.com/lesovsky/pgcenter?utm_source=postgresweekly&utm_medium=email) Lesovsky Alexey#code [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/137) [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