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

Postgres Weekly Issue 26 - September 4, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/26)**Postgres Weekly****Issue 26**
September 4, 2013Featured[Conference Schedule - PGConf.EU 2013](http://www.postgresql.eu/events/schedule/pgconfeu2013/?utm_source=postgresweekly&utm_medium=email)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](http://michael.otacoo.com/postgresql-2/playing-with-large-objects-in-postgres/?utm_source=postgresweekly&utm_medium=email)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](http://blog.sensible.io/2013/08/24/postgresql-sequences-and-array-column-types.html?utm_source=postgresweekly&utm_medium=email)_Sensible.io_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.__Heroku_[![\](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)The rest[Window Functions](http://tapoueh.org/blog/2013/08/20-Window-Functions?utm_source=postgresweekly&utm_medium=email)Window functions continue to be an area that a lot of people find useful but an equal number [remain confused by](https://twitter.com/jacobian/status/369477006607409152). Here’s another great attempt at simplifying them._Dimitri Fontaine_[Tuple Flensing II: Treating Postgres Corruption](http://www.bitrotincarnate.com/blog/2013/09/02/tuple-flensing-treating-postgres-corruption-part-ii/?utm_source=postgresweekly&utm_medium=email)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)](http://www.slideshare.net/linuxpoet/dumb-simple-postgresql-performance-nycpug?utm_source=postgresweekly&utm_medium=email)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](https://twitter.com/dartdog/status/374274537786851328?utm_source=postgresweekly&utm_medium=email)140 characters of wisdom about using Postgres in dev/staging and production environments to minimize bugs._Twitter_[PostGIS 2.1.0 Released](http://postgis.net/2013/08/17/postgis-2-1-0?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|*)