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

Postgres Weekly Issue 66 - July 30, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/66)**Postgres Weekly****Issue 66**
July 30, 2014[PostgreSQL 9.4 Beta 2 Released](http://www.postgresql.org/about/news/1533/?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 brings logical decoding, a new jsonb format, and improvements to materialized views. The second beta is now available for you to begin exploring and trying it out. Make sure to pass along your feedback to the Postgres developers._postgresql.org_[The End of PostgreSQL 8.4 - A Small Tribute](http://blog.hagander.net/archives/221-The-end-of-PostgreSQL-8.4-a-small-tribute.html?utm_source=postgresweekly&utm_medium=email)Postgres 8.4 is now officially end of life. With it came a lot of improvements that really started the path forward for Postgres’ resurgence. Here’s a look back ad a few of those highlights._Magnus Hagander_[PostgreSQL Updates 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22 Released](http://www.postgresql.org/about/news/1534/?utm_source=postgresweekly&utm_medium=email)Minor releases which fix a variety of issues on the 9.3, 9.2, 9.1, 9.0, and 8.4 branches._postgresql.org_[All Your Base Database Conference - Early Birds End Friday](http://allyourbaseconf.com/2014/?source=postgres?utm_source=postgresweekly&utm_medium=email)Backend developers, DevOps & Solutions Architects, join us in Oxford on 17 October to hear from database creators & industry leaders working at the coal face on where to store & how to handle your data. Early Bird tickets end Friday 1 August._All Your Base ConfSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/23905/t.png)](http://allyourbaseconf.com/2014/?source=postgres?utm_source=postgresweekly&utm_medium=email)[How to Terminate PostgreSQL Sessions](http://blog.sleeplessbeastie.eu/2014/07/23/how-to-terminate-postgresql-sessions/?utm_source=postgresweekly&utm_medium=email)Long running queries can affect a database in a variety of ways. At times you may want to have more insight and control, in some cases killing queries. Here’s a quick playbook on all of the above._Milosz Galazka_[Friends Don’t Let Friends Use Loops](http://bonesmoses.org/2014/07/25/friends-dont-let-friends-use-loops/?utm_source=postgresweekly&utm_medium=email)Bulk loading data is a common task at times for many applications, but doing so the naive way can lead to a lot more pain than is necessary for your database._Shaun M. Thomas_[pghero: Database insights made easy](https://github.com/ankane/pghero?utm_source=postgresweekly&utm_medium=email)Taking inspiration from [Heroku](http://www.heroku.com) and in particular their [pg-extras](https://github.com/heroku/heroku-pg-extras) plug-in to give you more insight into your data. Here’s a standalone app that will give you lots of key useful information about your database._Andrew Kane_[Optimization Issues: Cross Column Correlation](http://www.cybertec.at/optimization-issues-cross-column-correlation/?utm_source=postgresweekly&utm_medium=email)The Postgres optimizer is generally quite good, but that doesn’t mean there aren’t edge cases. Check out an interesting case here when cross correlating data._Hans-Juergen Schoenig_[Tales from the Trenches – the New MongoDB FDW](http://blogs.enterprisedb.com/2014/07/24/tales-from-the-trenches-the-new-mongodb-fdw/?utm_source=postgresweekly&utm_medium=email)Foreign data wrappers offer a lot of promise for the future of disparate datasets, but many of them aren’t quite there today. The Postgres one saw great strides in 9.3 and now Enterprise DB is advancing the Mongo one, here’s some great details around it._Jason Davis_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|*)