---
title: "This Week's PostgreSQL News (#159)"
publication: "Postgres Weekly"
issue: 159
published_at: "2016-06-01"
canonical_url: "https://postgresweekly.com/issues/159"
---

Postgres Weekly 159   . 

[Read this on the Web](http://postgresweekly.com/issues/159) 

[Postgres Weekly](http://postgresweekly.com) Issue 159 — June 1, 2016     

[3 Surprising PostgreSQL Indexing Tricks](http://blog.scoutapp.com/articles/2016/05/31/3-postgresql-indexing-tricks-that-surprise-everyone?utm_source=postgresweekly&utm_medium=email)Postgres provides a lot of flexibility with indexes, but you can end up with a result that isn’t ideal. Here’s a few Ruby and Rails-flavored tricks to help you make the right choice for your situation. Greg Navis [Several Queries to Monitor PostgreSQL](https://github.com/nilenso/postgresql-monitoring?utm_source=postgresweekly&utm_medium=email)Compiled from multiple sources like the Postgres wiki and check_postgres. Nilenso Software#tools [A Two Month Debugging Story](https://kev.inburke.com/kevin/a-two-month-debugging-story/?utm_source=postgresweekly&utm_medium=email)A look under the covers at debugging an issue in Postgres around auto-vacuum. A good look for understanding what happens under the hood of Postgres. Kevin Burke [Cross-Database Querying in PostgreSQL](https://www.compose.io/articles/cross-database-querying-in-compose-postgresql/?utm_source=cooper&utm_medium=postgres-newsletter&utm_campaign=cross-db-querying)In Compose PostgreSQL you can now perform cross-database queries using some extensions we've recently made available: postgres_fdw and dblink. In this article we'll walk through how to set up your database to take advantage of them. Compose#sponsored[![\](https://copm.s3.amazonaws.com/4fd6218a.png)](https://www.compose.io/articles/cross-database-querying-in-compose-postgresql/?utm_source=cooper&utm_medium=postgres-newsletter&utm_campaign=cross-db-querying) [Redesigning A Notification System using Postgres](http://blog.garage-coding.com/2016/05/25/redesigning-notification.html?utm_source=postgresweekly&utm_medium=email)Postgres’ listen/notify support (pub/sub) is a great option for a notification system. If you’re looking for a thorough walkthrough of what you can do, this is your guide. Upstats [Indiscriminate Use of CTEs Considered Harmful](http://adpgtech.blogspot.com/2016/05/indiscriminate-use-of-ctes-considered.html?utm_source=postgresweekly&utm_medium=email) Andrew Dunstan#opinion [EnterpriseDB Wraps PostgreSQL Into An Enterprise-Grade Suite to Challenge Oracle](http://www.v3.co.uk/v3-uk/news/2458970/enterprisedb-wraps-postgresql-into-an-enterprise-grade-suite-to-challenge-oracle?utm_source=postgresweekly&utm_medium=email)EnterpriseDB is adding tools to its PostgreSQL distribution to challenge the big commercial databases. Daniel Robinson#news [How to Move From Amazon RDS to A Dedicated PostgreSQL Server](http://layer0.authentise.com/how-to-move-from-amazon-rds-to-dedicated-postgresql-server.html?utm_source=postgresweekly&utm_medium=email) Authentise, Inc#tutorial [Set Up Scheduled PostgreSQL Backup to AWS S3 using wal-e](https://edwardsamuel.wordpress.com/2016/05/24/set-up-scheduled-postgresql-backup-to-aws-s3-using-wal-e/?utm_source=postgresweekly&utm_medium=email)[WAL-E](https://github.com/wal-e/wal-e) is one of, if not the, most popular tools for continous archiving the Postgres Write-Ahead-Log to S3. Here’s your perfect step-by-step guide in getting things setup. Edward Samuel Pasaribu [Instant APIs for Postgres](https://www.dreamfactory.com/signup/instant-api-for-postgresql?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=instant)DreamFactory auto-generates APIs and enables data and service bundling across multiple servers and DBs. Supports V8, Node.js, PHP, and Python for custom scripting. DreamFactory#sponsored [Relocatable PostgreSQL Builds](https://begriffs.com/posts/2016-05-21-relocatable-postgresql.html?utm_source=postgresweekly&utm_medium=email)Postgres like so many developer tools isn’t always portable, but that doesn’t have to be the case. This simple guide lays out whats actually stored where and how you can better move things around. Joe Nelson [Using Postgres Window Functions to Link Data Across Many Sources](https://labs.opendoor.com/2016/05/13/index-groups-postgres?utm_source=postgresweekly&utm_medium=email) Kevin Teh [Django and PostgreSQL Composite Types](https://blogs.gnome.org/danni/2016/05/22/django-and-postgresql-composite-types/?utm_source=postgresweekly&utm_medium=email)Composite types in Postgres can be extremely powerful, but not all frameworks are so friendly in working with them. Fortunately Django just got a bit friendlier.. Danielle Madeley [Barman 1.6.1 Released](http://www.postgresql.org/about/news/1671/?utm_source=postgresweekly&utm_medium=email)This minor release introduces support for ‘–peek’ option and for the ‘get-wal’ command which allows users to implement parallel remote restore commands on standby servers and during recovery. PostgreSQL#tools [Apply to 100 top tech companies with 1 application](http://www.indeed.com/prime?kw=postgresweekly&sid=xp_cooperpress_job)Indeed Prime connects top tech talent with top tech companies in the US. Companies compete to hire developers on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime. Indeed.​com#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/159) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK