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

Postgres Weekly 95   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 95 — March 4, 2015     

[The History of Replication in PostgreSQL](http://peter.eisentraut.org/blog/2015/03/03/the-history-of-replication-in-postgresql/?utm_source=postgresweekly&utm_medium=email)A lack of replication support in Postgres was a key reason for people picking MySQL over Postgres until about 5 years ago. Since then, Postgres has come a long way with replication and here’s a look at how it all came together. Peter Eisentraut [Document Storage Gymnastics with Postgres](http://rob.conery.io/2015/03/01/document-storage-gymnastics-in-postgres/?utm_source=postgresweekly&utm_medium=email)For single-node deployments Postgres is now a clear winner when it comes to document storage (versus MongoDB). This deep dive looks at how to take advantage of Postgres’ document storage, how to use indexes for optimization and also highlights cases where Postgres particularly excels. Rob Conery [Resolve Database Performance Issues Quickly](https://www.appdynamics.com/freetrial?utm_source=postgresweekly&utm_medium=email)AppDynamics' self-learning platform allows you to analyze actual database performance and detect anomalies automatically. It takes the guesswork out of defining optimal performance. Installs in Minutes. [Start Free Monitoring](https://www.appdynamics.com/freetrial?utm_source=cooperpress=sponsorship=postgres%20weekly=resolve%20database%20performance%20issues%20quickly=) AppDynamics#sponsored[![\](https://copm.s3.amazonaws.com/0718a665.png)](https://www.appdynamics.com/freetrial?utm_source=postgresweekly&utm_medium=email) [PoWA 2: Finding the Missing Index](http://www.postgresql.org/about/news/1572/?utm_source=postgresweekly&utm_medium=email)The first major update to the Postgres workload analyzer (PoWA) includes the ability to identify missing indexes your app would benefit from. Postgresql.​org [Tree Structure Query with PostgreSQL](http://truongtx.me/2014/02/28/tree-structure-query-with-postgresql/?utm_source=postgresweekly&utm_medium=email)Hierarchical structures are common in apps but don’t lend themselves to simple representations in relational databases. Fortunately, Postgres has a few tools to make things a bit smoother for you. Trường TX [Is PostgreSQL Your Next JSON Database?](https://blog.compose.io/is-postgresql-your-next-json-database/?utm_source=postgresweekly&utm_medium=email)A look at how JSON in Postgres can work well for you. Compose [It’s Time To Get Over That Stored Procedure Aversion You Have](http://rob.conery.io/2015/02/21/its-time-to-get-over-that-stored-procedure-aversion-you-have/?utm_source=postgresweekly&utm_medium=email)A provoking opinion piece. “Stored Procedures are not inherently bad – you’ve been told this because someone thinks you’re not capable of thinking for yourself.” Rob Conery [PostgreSQL Performance Tuning](http://momjian.us/main/writings/pgsql/hw_performance/?utm_source=postgresweekly&utm_medium=email)This older post is still very relevant if you’re running Postgres on your own hardware. The short version is that Postgres generally works well out of the box, but if you’re configuring your own system there are some useful things to pay attention to. Bruce Momjian [Job: Software Engineer @ Blue Apron (New York, NY)](https://www.blueapron.com/pages/jobs?gh_jid=11091&utm_source=postgresweekly&utm_medium=email)If you're passionate about food and building supply chain and warehouse management systems from the ground up, give us a look. Our team's at 16 developers and growing...quickly. Blue Apron#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/95) [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