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

Postgres Weekly Issue 83 - November 26, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/83)**Postgres Weekly****Issue 83**
November 26, 2014[PostgreSQL 9.4 RC1 Released](http://www.postgresql.org/message-id/CA+OCxoxTG58KksSum8OOrGR8rGTh2ACFgwy0=ibfBSWZ2qvw5w@mail.gmail.com?utm_source=postgresweekly&utm_medium=email)We’ve been talking about Postgres 9.4 for [a while](http://www.craigkerstiens.com/2014/03/24/Postgres-9.4-Looking-up/), and while the full 1.0 release of it isn’t here yet, we’re now much closer with the first release candidate. This RC promises stable interfaces so you can start building your apps against it now._postgresql.org_[Waiting For 9.5 – Support Arrays as Input to array_agg() and ARRAY(SELECT …)](http://www.depesz.com/2014/11/25/waiting-for-9-5-support-arrays-as-input-to-array_agg-and-arrayselect/?utm_source=postgresweekly&utm_medium=email)While we’re still waiting for the full release of 9.4, 9.5 is already racking up the features. Here’s an incremental improvement to some of the array functionality which should be handy._Hubert depesz Lubaczewski_[CitusDB: horizontally scalable Postgres for fast and reliable SQL](http://citusdata.com/blog/86-making-postgresql-scale-hadoop-style?utm_source=cooperpress=email=nov16postgresweekly?utm_source=postgresweekly&utm_medium=email)Scalable SQL solutions like Impala and SparkSQL have been in the spotlight recently. Read how CitusDB [delivers superior SQL query performance and reliability](http://citusdata.com/blog/86-making-postgresql-scale-hadoop-style?utm_source=cooperpress=email=nov16postgresweekly) while enabling you to use familiar Postgres clients, extensions and tools. To get a quick overview of how CitusDB scales Postgres see [our video](http://citusdata.com/video?utm_source=cooperpress=email=nov16postgresweekly)._Citus DataSponsored_[Representing Trees in PostgreSQL](http://woss.name/articles/representing-trees-in-postgresql/?utm_source=postgresweekly&utm_medium=email)It’s not every application that needs to model some tree/hierarchical structure, but when you do databases are the most natural way for it. Here’s a look at what’s available and a great analysis of approaching the problem._Graeme Mathieson_[Medians in SQL](https://www.periscope.io/blog/medians-in-sql.html?utm_source=postgresweekly&utm_medium=email)SQL makes basic sum, averages, and other mathematical operations easy, but certain ones like medians or 95/99th percentiles can be tougher. Here’s a great post showing the tools available to help get medians and others._Periscope_[The Big Book of PostgreSQL](http://blogs.enterprisedb.com/2014/11/20/the-big-book-of-postgresql/?utm_source=postgresweekly&utm_medium=email)An opinion piece on what makes the Postgres documentation great, though whether you consider it great or not I’d love to hear as that’s often a common point of contention. Let us know [@PostgresWeekly](http://www.twitter.com/postgresweekly) how you feel it it ranks._Thom Brown_[New OSS Tool Links Postgres and MySQL](http://blogs.enterprisedb.com/2014/11/13/new-os-tool-links-postgres-and-mysql/?utm_source=postgresweekly&utm_medium=email)Have instances of both Postgres and MySQL and want to connect data between both? Here’s a tool to help with that._EnterpriseDB_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|*)