Postgres Weekly Issue 31
October 9, 2013
Featured
A Postgres 9.3 Overview [PDF]
Postgres 9.3 is still fairly fresh enough that most people haven’t upgraded yet. If you need to find a good excuse you can likely find it in this clear and concise presentation on Postgres 9.3 features.
Bruce Momijan
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
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.
The rest
The Cost of Reliability
Checksums are one of the less talked about features that came with Postgres 9.3. Here’s a dive into the performance overhead they incur. While valid improvements to usability can be made they can definitely made the case of identifying corruption a much easier one, thus allowing fixes to happen more proactively.
eVOL Monkey DBA
Radius Queries in Postgres
Postgres is packed with several useful extensions right out of the box. Whether its full text search, a key value data store, or something else its likely already available. Here’s a great highlight of one such extension to compute distance between points.
DataChomp
Hstore Development for 9.4 Release
Years ago we got hstore within Postgres, a flexible key-value datatype. Postgres 9.2 brought JSON, and shortly after came PLV8. All of these have their limitations and from the developer that brought us hstore some improvements are underway for Postgres 9.4 to solve many of these issues in one fell swoop.
PostgreSQL Views Screencast
A (paid) screencast from Mark Bates.
MetaCasts.tv
Jobs
Database Administrator at Uber (San Francisco, CA)
Uber is an ambitious and exciting company dedicated to disrupt the transportation industry. They’re looking for a database admin with PostgreSQL DBA experience, solid fundamentals in database management, and knowledge of PostgreSQL 9 onward.
Uber