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

Postgres Weekly Issue 84 - December 3, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/84)**Postgres Weekly****Issue 84**
December 3, 2014[PostgreSQL’s Powerful New Join Type: LATERAL](http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/?utm_source=postgresweekly&utm_medium=email)The last version of Postgres picked up a new join type – Lateral. However it’s not the most simply explained or easy to follow, but Heap analytics does a good job of it with a great example of how you’d use it._Dan Robinson_[PSequel: A PostgreSQL GUI Tool for Mac OS X](http://www.psequel.com/?utm_source=postgresweekly&utm_medium=email)If you’ve tried [psql](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/), but still found it lacking and want something more graphical for connecting to and working with your Postgres database here’s yet another option._psequel_[Know Your Postgres Backup and Recovery](http://www.enterprisedb.com/store/products/dba-training/01t50000001uaSBAAY=CP7BURt?utm_source=postgresweekly&utm_medium=email)30% of Postgres users studied in our recent research would have been slow or unable to recover from failure. 43% could not execute a point-in-time recovery, and some had NO backup in place. Don’t let this be you. Invest a few hours [learning important backup and recovery techniques](http://www.enterprisedb.com/store/products/dba-training/01t50000001uaSBAAY&ls=CP7BURb), so you can re-evaluate your recovery requirements and use appropriate strategies and procedures._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000001uaSBAAY=CP7BURt?utm_source=postgresweekly&utm_medium=email)[When Postgres Will Not Start](http://blog.endpoint.com/2014/11/when-postgres-will-not-start.html?utm_source=postgresweekly&utm_medium=email)Sometimes Postgres crashes, this isn’t the end of the world you simply restart it. When it doesn’t restart right away is when you start to worry. Here’s an awesome post to keep in the back of your pocket for these disaster situations of what steps to follow._Endpoint_[Have Some (Referential) Integrity with Foreign Keys](http://robots.thoughtbot.com/referential-integrity-with-foreign-keys?utm_source=postgresweekly&utm_medium=email)Rails out of the box will help you to create foreign key references in the application layer, but doesn’t often enforce this at the data layer. Fortunately this isn’t to hard to put in and gain a better sense of security for your data._Thoughtbot_[PagerDuty analytics with Postgres](https://stripe.com/blog/pagerduty-analytics-with-pd2pg?utm_source=postgresweekly&utm_medium=email)Use PagerDuty but want to better analyze your data? Here’s a tool from Stripe, and more specifically a former colleague [@mmcgrana](http://www.twitter.com/mmcgrana), which will sync your PagerDuty data into a Postgres DB for ease of querying._Stripe_[Postgres Tree Shootout part 2: Adjacency List using CTEs](http://schinckel.net/2014/11/27/postgres-tree-shootout-part-2%3A-adjacency-list-using-ctes/?utm_source=postgresweekly&utm_medium=email)Here’s the part two follow on to building and managing Tree structures within Postgres. A great deeper dive for when you need this in your application and some sane tips for helping with it._Matthew Schinckel_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|*)