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

Postgres Weekly Issue 34 - October 30, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/34)**Postgres Weekly****Issue 34**
October 30, 2013[What production OS do you use with PostgreSQL?](http://www.postgresql.org/community/?os=version?utm_source=postgresweekly&utm_medium=email)The PostgreSQL community wants your feedback around what version of the Postgres distribution you use in production._PostgreSQL.org_[17 Years of PostgreSQL in 4 Minutes (video)](http://www.youtube.com/watch?v=HsxwNvlKZRU?utm_source=postgresweekly&utm_medium=email)Here's a fun visualization of all the commits to Postgres over the years._YouTube_[Testing Nested hstore](http://theory.so/pg/2013/10/23/testing-nested-hstore/?utm_source=postgresweekly&utm_medium=email)Hstore is already a great key-value store in Postgres which supports rich indexing. Work is being done, with the goal being for Postgres 9.4, to make hstore even more powerful by allowing nesting. Here’s a look at some of the performance benefits that may come along with it._David E. Wheeler_[Auto generate UUID with Postgres and Rails 4](http://blog.lingohub.com/developers/2013/10/dev-bit-auto-generate-uuid-postgres-rails-4/?utm_source=postgresweekly&utm_medium=email)UUIDs are great to use within your application instead of sequential IDs because they can make scaling easier later. Here’s a guide to using them directly within your application on Rails._LingoHub_[Denormalizing Tags](http://tapoueh.org/blog/2013/10/23-denormalizing-tags.html?utm_source=postgresweekly&utm_medium=email)Tagging is common in a ton of applications and it can be done very efficiently within Postgres with the use of arrays. Theres also a great use of one of my personal favorite functions within here, array_agg._Dimitri Fontaine_[How To: Shove Data Into Postgres Using Goroutines (Gophers) and GoLang](http://www.acloudtree.com/how-to-shove-data-into-postgres-using-goroutinesgophers-and-golang/?utm_source=postgresweekly&utm_medium=email)Go is a language thats quickly growing in popularity, while as much about Go as it is about Postgres, here’s a nice guide on prototyping inserting data into PostgreSQL from Go and scaling it up to 1,000,000 writes._Jared Folkins_From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

_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._[![\](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)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|*)