| Postgres Weekly | Issue 60
June 4, 2014
|
| | A Better ID Generator For PostgreSQL | |
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 | |
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 | |
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 | |
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 | |
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 | |
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.
| | Heroku Sponsored |
|  |
| Django/Postgres News: Arrays Merged | |
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 |
|
| |
|