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

Postgres Weekly Issue 74 - September 24, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/74)**Postgres Weekly****Issue 74**
September 24, 2014[Auditing Data Modifications In Postgres](http://www.garysieling.com/blog/auditing-data-changes-postgres?utm_source=postgresweekly&utm_medium=email)Your data is always important, but in some cases you want extra auditing. Here’s a great initial dive into how to set it up and what impacts it may have on your DB.[JSON in PostgreSQL](http://scanningpages.files.wordpress.com/2014/09/pg_json.pdf?utm_source=postgresweekly&utm_medium=email)As 9.4 gets closer and closer everyone is awaiting JSONB. Of course JSON is already available, but if you’re unfamiliar here’s your start. And the slides continue on into a comparison between the two formats.[PostgreSQL Offsets and Pagination Performance](http://blog.clearbit.co/postgres-offsets?utm_source=postgresweekly&utm_medium=email)Postgres can have some trouble performing well with high offsets on queries. Cursors can be a solution but have their own flaws. Alex MacCaw looks at another approach._Alex MacCaw_[Mastering the Postgres Rollout - Follow the Yellow Brick Road?](http://blogs.enterprisedb.com/2014/05/26/mastering-the-postgres-rollout-2/?utm_source=CP=NL=4PostgresRollout?utm_source=postgresweekly&utm_medium=email)That famous journey began simply, but quickly entered some challenging territory. For DBAs on the road to building more sophisticated environments to support their new Postgres deployments, the same may be true. High availability, replication and performance tuning can present bumps in the road, but here are some ideas on how to approach with caution._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://blogs.enterprisedb.com/2014/05/26/mastering-the-postgres-rollout-2/?utm_source=CP=NL=4PostgresRollout?utm_source=postgresweekly&utm_medium=email)[Finding Duplicate Indexes](http://www.databasesoup.com/2014/09/finding-duplicate-indexes.html?utm_source=postgresweekly&utm_medium=email)A look at some SQL queries you can use to seek out duplicate and overlapping indexes on your database._Database Soup_[Settings for A Fast pg_restore](http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html?utm_source=postgresweekly&utm_medium=email)pg_restore is a utility for restoring a Postgres database from an archive, but what settings can you use with Postgres to make it import as quickly as possible?_Database Soup_[Vagrant with Docker: How to set up Postgres, Elasticsearch and Redis on OS X](http://maori.geek.nz/post/vagrant_with_docker_how_to_set_up_postgres_elasticsearch_and_redis_on_mac_os_x?utm_source=postgresweekly&utm_medium=email)_Graham Jenson_[Writing Better PostGIS Queries (Spatial and Geographic Objects for PostgreSQL)](https://vimeo.com/106846193?utm_source=postgresweekly&utm_medium=email)At FOSS4G, Regina Obe gave a talk about taking advantage of spatial indexes, SQL constructs, and PostGIS specific functions alongside Postgres 9.3._FOSS4G_[dockerfdw: Docker FDW](https://github.com/paultag/dockerfdw?utm_source=postgresweekly&utm_medium=email)Want to have an inventory of your docker containers directly in Postgres, well now there’s a convenient FDW for you._Paul Tagliamonte_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|*)