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

Postgres Weekly Issue 71 - September 3, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/71)**Postgres Weekly****Issue 71**
September 3, 2014[PGConf.EU 2014 schedule posted: Matt Asay to deliver keynote](http://www.postgresql.org/about/news/1540/?utm_source=postgresweekly&utm_medium=email)PGConf EU is happening in Madrid this year which sounds like a great location, in addition there’s [a great lineup](http://www.postgresql.eu/events/schedule/pgconfeu2014/) of talks. Including what makes to be an interesting keynote from Matt Asay, Vice President of Community at MongoDB._postgresql.org_[Postgres multicolumn indexes to save the day](https://jve.linuxwall.info/blog/index.php?post/2014/08/27/Postgres-s-multicolumn-index-to-save-the-day?utm_source=postgresweekly&utm_medium=email)Indexes are great things that will make your database perform better, but in Postgres you have a few options from functional and conditional ones, to the different types - BTree, GIN, GiST, KNN, SP-GiST. Multicolumn indexes while maybe not your most commonly used, when needed can be extremely effective._Julien Vehent_[Postgres Skills are in Demand - Add to your skill set and get certified](http://www.enterprisedb.com/products-services-training/training=CP?utm_source=postgresweekly&utm_medium=email)1000+ jobs are posted each month listing Postgres skills – enhance your talents and get certified with expert training courses. The EDB certification program sets the global standard for Postgres professionals, and is definitive proof of your Postgres skills._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/products-services-training/training=CP?utm_source=postgresweekly&utm_medium=email)[Replicated PostgreSQL with pgpool2](http://michael.stapelberg.de/Artikel/replicated_postgresql_with_pgpool?utm_source=postgresweekly&utm_medium=email)If you’re running a Postgres installation yourself you want some form of replication setup. Of course there’s lots of options such as [WAL-E](https://github.com/wal-e/wal-e) and [Barman](http://www.pgbarman.org/), and then there’s PG Pool which handles quite a few things beyond just replication. Here’s your perfect guide for getting at least the replication and failover setup._Michael Stapelberg_[Waiting for Postgres 9.5: Add min and max aggregates for inet/cidr data types](http://www.depesz.com/2014/09/03/waiting-for-9-5-add-min-and-max-aggregates-for-inetcidr-data-types/?utm_source=postgresweekly&utm_medium=email)Using inet within Postgres? If you’ve got the specific use case of wanting to find the min and max in some grouping, it’s going to be available in 9.5. While likely not earth shattering with each new function, Postgres becomes even more user friendly._Hubert depesz Lubaczewski_[Streaming directly into Postgres with Hapi.js and pg-copy-stream](http://maori.geek.nz/post/streaming_directly_into_postgres_with_hapi_js_and_pg_copy_stream?utm_source=postgresweekly&utm_medium=email)The copy command is extremely handy for bulk loading data, if you’re doing anything with inserting lots of data it’s what you want to use. Here’s an awesome example of a Node app taking advantage of just that and getting a 10x performance improvement over plain inserts._Graham Jenson_[Many to many relationships with Postgresql's hstore in Rails 4](http://pothibo.com/2014/9/many-to-many-relationships-with-postgresql-s-hstore-in-rails-4?utm_source=postgresweekly&utm_medium=email)[Hstore](http://postgresguide.com/sexy/hstore.html) is awesome and powerful in Postgres, and the more people take advantage of it in their [frameworks like Django](http://www.craigkerstiens.com/2012/06/11/schemaless-django/) and [Rails](http://jes.al/2013/11/using-postgres-hstore-rails4/) the more benefit you find. Here’s the latest example going even further providing many to many relationships directly in rails with ActiveRecord._Pier-Olivier Thibault_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|*)