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

Postgres Weekly Issue 19 - July 17, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/19)**Postgres Weekly****Issue 19**
July 17, 2013As always, a big thanks to [Craig Kerstiens](https://twitter.com/craigkerstiens) for curating Postgres Weekly and if you want to recommend anything for a future issue, tweet @craigkerstiens and he'll consider it! :-)Featured[Archiving Data as Fast as Possible](http://tapoueh.org/blog/2013/07/05-archiving-data-fast.html?utm_source=postgresweekly&utm_medium=email)In almost every sense data is continuing to grow, sometimes faster than we can analyze it. Managing this by offloading old data to allow your dataset to be workable is important. This article highlights some of the best ways as well as the future of this process within PostgreSQL.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._[![\](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[Call Me Maybe: Carly Rae Jepsen and the Perils of Network Partitions](http://www.youtube.com/watch?v=mxdpqr-loyA?utm_source=postgresweekly&utm_medium=email)Network partitions are real, but their practical consequences on complex applications are poorly understood. Kyle Kingsbury looks at interesting ways he's found to lose important data, the challenge of building systems which are reliable under partitions, and what it means for you. Covers Postgres, Redis, and Riak._YouTube_[RECURSIVE Query is Recursive](http://practiceovertheory.com/blog/2013/07/12/recursive-query-is-recursive/?utm_source=postgresweekly&utm_medium=email)If you've ever run a several queries in succession to find for example a child node you've done more work than needed. Here's a great overview of how recursive queries in Postgres work with real world example of when you'd use such.[The State of SQL Education](https://chartio.com/blog/2013/07/the-state-of-sql-education?utm_source=postgresweekly&utm_medium=email)For those that are entirely new to Postgres and databases in general you aren't being overwhelmed with intro content. Here's a great post that highlights three of the best resources, if you're new or someone you know is new to SQL start here.[Postgres 9.2: Monitoring Temp Files Generation in Real Time](http://www.pateldenish.com/2013/07/postgres-9-2-monitoring-temp-files-generation-in-real-time.html?utm_source=postgresweekly&utm_medium=email)Pg_stat_statements improvements in Postgres 9.2 probably can't get enough attention. Here's a great deep dive on one particular new addition to it which shows the number of temp files generated which can cause even broader performance impact.[audit-trigger: Simple, easily customised trigger-based auditing for PostgreSQL](https://github.com/2ndQuadrant/audit-trigger/blob/master/audit.sql?utm_source=postgresweekly&utm_medium=email)For certain use cases auditing is a most, and while not built directly into Postgres there are some good and simple solutions. Here's a simple, easily customised trigger-based auditing example for PostgreSQL._GitHub_[Faster JSON Generation with PostgreSQL](http://blog.hashrocket.com/posts/faster-json-generation-with-postgresql?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|*)