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

Postgres Weekly 199   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 199 — March 22, 2017     

[First Impressions of Google Cloud SQL for PostgreSQL](http://penningpence.blogspot.co.uk/2017/03/first-impressions-google-cloud-sql-for.html?utm_source=postgresweekly&utm_medium=email)One of the most exciting announcements of Google Next was Postgres support for Cloud SQL. Now that it’s available here’s a rundown of how it measures up. Payal Singh#opinion [Timescale: A Postgres-Compatible Open Source Time-Series Database](http://www.timescaledb.com/?utm_source=postgresweekly&utm_medium=email)SQL made scalable for time-series data. It’s Postgres compatible and optimized for fast ingest and complex queries. Timescale#tools [Postgres-BDR: Multi Master Replication Solution for PostgreSQL](https://2ndquadrant.com/en/resources/bdr/)Postgres-BDR is a multi-master replication system for geographically distributed clusters using highly efficient, asynchronous logical replication. It supports anything from 2 to more than 48 nodes in a distributed database. 2ndQuadrant PostgreSQL Products#sponsored[![\](https://copm.s3.amazonaws.com/022c4802.jpg)](https://2ndquadrant.com/en/resources/bdr/) [Find Your Way with The Power of PostGIS and PgRouting](https://blog.daftcode.pl/find-your-way-with-the-power-of-postgis-pgrouting-66d620ef201b?utm_source=postgresweekly&utm_medium=email)PostGIS is one of the most powerful GIS databases around. PgRouting is the part that helps you find paths and routes from one area to the other, and here’s how you can use it. Patryk Pastewski#tutorial [Unit Testing in Postgres with PLV8](https://legitimatesounding.com/blog/unit_testing_in_postgresql_with_plv8.html?utm_source=postgresweekly&utm_medium=email)Equinox is a testing framework built on top of PLV8 & Node.js where all tests are written in JS. Jerry Sievert#tutorial [Troubleshooting Streaming Replication [Slides\]](http://blog.postgresql-consulting.com/2017/03/slides-from-pgconf-ru-2017.html?utm_source=postgresweekly&utm_medium=email)A slidedeck from the recent PGConf RU conference in Moscow looking at troubleshooting streaming replication, and how you can quickly find/eliminate replication problems. Alexey Lesovsky [The Proliferation of NUMERIC](https://www.openscg.com/2017/03/proliferation-of-numeric/?utm_source=postgresweekly&utm_medium=email)NUMERIC is often used as a primary key type in Postgres due to automated migrations from Oracle. While mapping Oracle’s NUMBER to NUMERIC is easy, it can result in poor performance. Jim Mlodgenski#opinion [postgres_fdw Estimated Overhead](http://www.3manuek.com/fdwoverhead?utm_source=postgresweekly&utm_medium=email)A perf analysis of FDW (Foreign Data Wrapper) overhead on intensive transaction workloads. Emanuel Calvo#opinion [Are Hash Indexes Faster Than Btree Indexes?](https://amitkapila16.blogspot.com/2017/03/hash-indexes-are-faster-than-btree.html?utm_source=postgresweekly&utm_medium=email)Postgres supports a variety of index types. Here’s a look at the performance differences between hash and Btree (though be careful using them before Postgres 10 gets here). Amit Kapila#opinion [Get Instant REST APIs for Postgres](https://www.dreamfactory.com/signup?utm_campaign=Signup-03-22-17&utm_source=email&utm_medium=external-postgres&utm_term=postgres&utm_content=postgresql)DreamFactory turns your Postgres database into a comprehensive REST API. Free and open source, [try it now](https://www.dreamfactory.com/signup?utm_campaign=Try-it-now-03-22-17&utm_source=email&utm_medium=external-postgres&utm_term=postgres&utm_content=postgresql). DreamFactory#sponsored [Postgres Joins and Django Querysets](http://lucasroesler.com/2017/02/postgres-joins-and-django-querysets/?utm_source=postgresweekly&utm_medium=email)ORMs don’t always generate the most performant queries. This article looks at an example from Django and how it can be optimized. Lucas Roesler [Creating Tables 'dum' and 'dee' in Postgres](https://blog.jooq.org/2017/03/17/creating-tables-dum-and-dee-in-postgresql/?utm_source=postgresweekly&utm_medium=email)For the more theoretical amongst you. JOOQ#tutorial    

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