---
title: "This Week's PostgreSQL News (#51)"
publication: "Postgres Weekly"
issue: 51
published_at: "2014-03-26"
canonical_url: "https://postgresweekly.com/issues/51"
---

Postgres Weekly Issue 51 - March 26, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/51)**Postgres Weekly****Issue 51**
March 26, 2014[PostgreSQL Updates 9.3.4, 9.2.8, 9.1.13, 9.0.17, and 8.4.21 Released](http://www.postgresql.org/about/news/1511/?utm_source=postgresweekly&utm_medium=email)The PostgreSQL Global Development Group has released an update to all supported versions. 9.3.4 fixes a data corruption issue with replication and crash recovery, as well as several other minor issues in all versions._postgresql.org_[PostgreSQL 9.4 - Looking Up](http://www.craigkerstiens.com/2014/03/24/Postgres-9.4-Looking-up/?utm_source=postgresweekly&utm_medium=email)A few weeks back I wrote about some of the short comings of PostgreSQL 9.4. And then days after publishing things started to turn around with two big new features committed. Postgres 9.4 is shaping up to be an impressive release. Read for more about jsonb and logical decoding._Craig Kerstiens_[Jsonb has Been Committed to Postgres](http://obartunov.livejournal.com/177247.html?utm_source=postgresweekly&utm_medium=email)Jsonb has finally made its way into Postgres. With it Postgres continues to become even more powerful and useful, and the case for Mongo dwindles. If you’re unfamiliar with it, you can also dig into [the Postgres docs](http://www.postgresql.org/docs/devel/static/datatype-json.html)._Oleg Bartunov_[Postgresql Range Basics](http://www.davidhampgonsalves.com/Postgres-ranges/?utm_source=postgresweekly&utm_medium=email)With all the focus on whats new in Postgres there’s still some features from past releases that continue to deserve attention. Range types are an incredibly useful datatype that's worth being familiar with._David Hamp-Gonsalves_[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to._HerokuSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)[RECURSIVE Query is Recursive](http://practiceovertheory.com/blog/2013/07/12/recursive-query-is-recursive/?utm_source=postgresweekly&utm_medium=email)Recursion is common within application code, but often a bit more painful in your database requiring plpgsql or whatever procedural language your database uses. Postgres as one may expect makes this easier with CTEs._Harold Giménez_[Biggy Basics, Part 1: Documents](http://www.wekeroad.com/2014/02/26/biggy-basics-part-1/?utm_source=postgresweekly&utm_medium=email)For all the talk of document storage, most frameworks are still stuck with their standard ORMs. Here’s an [awesome solution](https://github.com/robconery/biggy) for .NET to make it easier to work with JSON documents directly in Postgres._Rob Conery_[CLUSTER table USING index;](http://hans.io/blog/2014/03/25/postgresql_cluster/index.html?utm_source=postgresweekly&utm_medium=email)For various applications and types of reporting where you’re dealing with a lot of data in a specific order both sequential scans and indexes can be slow an painful. Restructuring data on disk can really help in these cases, here’s how CLUSTER can do that for you._Hans Hasselberg_[What I Think of jsonb](http://pgeoghegan.blogspot.com/2014/03/what-i-think-of-jsonb.html?utm_source=postgresweekly&utm_medium=email)Jsonb is now committed and will be a big part of the future of Postgres. But it’s a bit more than just tacking on broader trends that exist (Mongo), JSON itself has much broader adoption and makes quite a bit of sense. Here’s a much deeper and technical dive into how PostgreSQL took to integrating it and improving upon what was already there._Peter Geoghegan_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)