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

Postgres Weekly 126   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 126 — October 7, 2015     

[PostgreSQL Monitoring Cheatsheet](http://russ.garrett.co.uk/2015/10/02/postgres-monitoring-cheatsheet/?utm_source=postgresweekly&utm_medium=email)If you run and manage your own Postgres database, there’s a handful of things that are important to keep your eye on. Here’s a handy cheatsheet of all the things to monitor. Russ Garrett [Combined Row-Based and Columnar Storage in PostgreSQL 9.5](https://www.citusdata.com/blog/14-marco/273-combined-row-based-and-columnar-storage-postgresql-95?utm_source=postgresweekly&utm_medium=email)Marco Slot looks at how to create a single table in which recent data is stored in a row-based format while older data is stored in a columnar format. Citus Data [pg_rewind - Resynchronizing Servers After Failover](https://www.youtube.com/watch?v=J4KzjHTx2WE&utm_source=postgresweekly&utm_medium=email)A 40 minute talk about pg_rewind, a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. Heikki Linakangas#video [Tailor metrics and alerts for your PostgreSQL](http://dtdg.co/1OhYXXg)If your database performance suffers, you want to know before it is apparent to your end users. With Datadog, you can set and track custom metrics for your database, and implement unique alerts that make sense for your application. Try it Free Today! Datadog#sponsored[![\](https://copm.s3.amazonaws.com/72932fd4.png)](http://dtdg.co/1OhYXXg) [How to Make a Box-and-Whisker Plot in SQL](https://blog.modeanalytics.com/how-to-make-box-and-whisker-plot-sql/?utm_source=postgresweekly&utm_medium=email)Understanding how your data is distributed is critical for any analysis. Box-and-whisker plots are great for summarizing distributions and comparing distributions across datasets. Here’s how to create them in SQL. Benn Stancil [Ask HN: Implementing a graph database using Postgres tables?](https://news.ycombinator.com/item?id=10316872&utm_source=postgresweekly&utm_medium=email)An interesting discussion about taking one of the new trends in databases–graph databases, and attempting to replicate that functionality directly in Postgres. Hacker News [Tempgres: Temporary PostgreSQL Databases On Demand](https://github.com/ClockworkConsulting/tempgres-server?utm_source=postgresweekly&utm_medium=email)tempgres is a REST service which for conveniently creating temporary PostgreSQL databases intended for use from tests. Clockwork Consulting#code [PostgreSQL Replication with Londiste from Skytools 3](https://blog.lateral.io/2015/09/postgresql-replication-with-londiste-from-skytools-3/?utm_source=postgresweekly&utm_medium=email)A look at how a team migrated their multiple Postgres databases between cloud providers using Londiste, an asynchronous master/slave replication system. Lateral [PostgreSQL and NodeJS](http://mherman.org/blog/2015/02/12/postgresql-and-nodejs/?utm_source=postgresweekly&utm_medium=email)Want to get up and running from scratch with a Node app and Postgres? Here’s an end to end walk through if you don’t already have a workflow of your own. Michael Herman [Postgres Performance in 15 Minutes](http://jberkus.github.io/performance_in_15_min/index.html?utm_source=postgresweekly&utm_medium=email#1)A slide deck based on a talk from Josh Berkus at DjangoCon US 2015. Josh Berkus    

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