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

Postgres Weekly Issue 60 - June 4, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/60)**Postgres Weekly****Issue 60**
June 4, 2014[A Better ID Generator For PostgreSQL](http://www.wekeroad.com/2014/05/29/a-better-id-generator-for-postgresql/?utm_source=postgresweekly&utm_medium=email)It’s clear that integers aren’t always the best choice for IDs for a database. UUIDs are generally accepted as pretty reasonable, but this article goes a little bit further if you’re planning to shard and scale._Rob Conery_[PGCon 2014 Unconference: A Community](http://bonesmoses.org/2014/05/27/pgcon-2014-unconference-a-community/?utm_source=postgresweekly&utm_medium=email)Never been to pgcon (the small conference of Postgres community hackers)? Or furthermore, never been to the unconference (which follows), comprised of mostly key community members? Here’s a great recap of the experience and why you should be there next year._Shaun M. Thomas_[Table Partitioning and Foreign Keys](http://www.keithf4.com/table-partitioning-and-foreign-keys/?utm_source=postgresweekly&utm_medium=email)Partitioning, in particular table partitioning and foreign keys don’t always play so friendly. At the same time both can be important. Here’s a deeper dive into working with the two, and the considerations that need to be kept in mind._keithf4_[Postgres 9.4 Feature Highlight: Logical Replication Receiver](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-logical-replication-receiver/?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 comes with a foundation of logical replication, but to take full advantage you need to do a little extra work. Here’s a blog post that takes you further in how to take advantage of the foundation that’s been laid in the upcoming release._Michael Paquier_[Foreign Keys are Not Free](http://bonesmoses.org/2014/05/14/foreign-keys-are-not-free/?utm_source=postgresweekly&utm_medium=email)Foreign keys can drastically affect table performance. Here’s a quick look at why this is so with PostgreSQL in particular._Shaun M. Thomas_[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)[How to Format Numbers as Currency in Postgres, MySQL and Redshift](https://periscope.io/blog/how-to-format-numbers-as-currency-in-postgres-mysql-and-redshift.html?utm_source=postgresweekly&utm_medium=email)If you’re running any kind of business currency inevitably comes into play. Here’s a simple guide on formatting your numeric/float/datatype of your choice as proper currency making for prettier reports._Periscope_[Django/Postgres News: Arrays Merged](http://postgres.mjtamlyn.co.uk/arrays-merged.html?utm_source=postgresweekly&utm_medium=email)A few months back a Kickstarter was funded to make Postgres much better in Django. Here’s a big step forward with native array support now committed._Marc Tamlyn_[PostgreSQL Maestro 14.5 Released](http://www.sqlmaestro.com/products/postgresql/maestro/?utm_source=postgresweekly&utm_medium=email)The Windows GUI app for PostgreSQL database server administration and database development._SQL Maestro_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|*)