Postgres Weekly Issue 26
September 4, 2013
Featured
Conference Schedule - PGConf.EU 2013
The full conference schedule is now available for PG Conf EU which is happening at the end of October in Ireland. If you’re arleady planning to be there we’d love to chat with you there, and if you need more motivation just give the list of talks a look.
PostgreSQL.eu
Playing with Large Objects in Postgres
Postgres has a feature that lets you store large objects (up to 4 terabytes in size) in the database using dedicated catalog tables. Michael Paquier looks at some of the functionality.
Michael Paquier
PostgreSQL Sequences and Array Column Types
Sensible.io
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.
Heroku
The rest
Window Functions
Window functions continue to be an area that a lot of people find useful but an equal number remain confused by. Here’s another great attempt at simplifying them.
Dimitri Fontaine
Tuple Flensing II: Treating Postgres Corruption
If you made it through last week's feature on treating corruption in Postgres then make sure to give this follow on a look to get the full conclusion.
Dumb Simple PostgreSQL Performance (NYCPUG)
There can be plenty to worry about when it comes to paying attention to your database’s performance. A talk at the recent NY Postgres Users Group aimed to help simplify this.
SlideShare
Tom Brander: Use the Production DB in Dev
140 characters of wisdom about using Postgres in dev/staging and production environments to minimize bugs.
Twitter
PostGIS 2.1.0 Released