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

Postgres Weekly 175   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 175 — September 21, 2016     

[Dynamic Pivot Tables with JSON and PostgreSQL](http://bender.io/2016/09/18/dynamic-pivot-tables-with-json-and-postgresql/?utm_source=postgresweekly&utm_medium=email)When doing data analysis you don’t always have to resort to Excel or Hadoop. This post shows a simple way to do Pivot tables, which is extremely common when looking to analyze data. Andrew Bender [BedquiltDB v2: A JSON Document Store Built on Postgres](http://bedquiltdb.github.io/v2.html?utm_source=postgresweekly&utm_medium=email)Version 2 includes new query operators for matching JSON documents, and you can now get up and running fast with a simple Docker image. Shane Kilkelly#news [Improve PostgreSQL On Windows Performance by 100%](http://www.openscg.com/2016/09/improve-postgresql-windows-performance-by-100/?utm_source=postgresweekly&utm_medium=email)Most running Postgres know to tune shared buffers, but if you’re on Windows there’s one more setting to pay attention to. This article demonstrates using `update_process_title` for significant performance gains on Windows. David Rader [Itching for a rewrite? Try a Code Inspection™ from Corgibytes first.](http://corgibytes.com/)We know the frustration. You see all the places your app could be so much better, but you can't seem to convince your boss. Next time, mention Corgibytes. Our Code Inspection™ can help you explain technical improvements in a way executives can understand. Corgibytes#sponsored[![\](https://copm.s3.amazonaws.com/97df2076.png)](http://corgibytes.com/) [All About PostgreSQL Streaming Replication](https://www.opsdash.com/blog/postgresql-streaming-replication-howto.html?utm_source=postgresweekly&utm_medium=email)Streaming replication is the official approach from much of the community, which streams updates over the write ahead log to another instance. This guide provides a good overview of what you need to know and how to get started. RapidLoop [Aiven Brings Easy Hosted PostgreSQL to Microsoft Azure](https://www.postgresql.org/about/news/1695/?utm_source=postgresweekly&utm_medium=email) Postgresql.​org#news [BDR Is Coming to PostgreSQL 9.6](http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/?utm_source=postgresweekly&utm_medium=email)BDR is [bi-directional replication](https://2ndquadrant.com/en/resources/bdr/). Craig Ringer#news [BRIN Indexes in Postgres 9.5](http://dev.sortable.com/brin-indexes-in-postgres-9.5/?utm_source=postgresweekly&utm_medium=email)BRIN (or block range indexes) can be useful on large tables in certain cases, depending on the data and what you need. Here’s an explanation. Sortable Engineering#tutorial [Interview: Uber’s Postgres Problems with Evan Klitzke](http://softwareengineeringdaily.com/2016/09/09/ubers-postgres-problems-with-evan-klitzke/?utm_source=postgresweekly&utm_medium=email)A 50 minute podcast chat about the recent story on Uber’s switch from Postgres to MySQL. Software Engineering Daily [sQucumber-redshift: A Framework for Defining and Executing SQL Integration & Acceptance Tests on AWS Redshift](https://github.com/moertel/sQucumber-redshift?utm_source=postgresweekly&utm_medium=email) Stefanie Grunwald#tools [One More Time About Collation In PostgreSQL](https://simply.name/pg-lc-collate.html?utm_source=postgresweekly&utm_medium=email)Collation isn’t something you always need to worry about, but if ignored on a fresh OS install, it can bite you later. Here’s some advice on how to set up collation correctly when starting anew, and the impact it can have. Vladimir Borodin#code [Executing Custom SQL in Django Migrations](http://blog.endpoint.com/2016/09/executing-custom-sql-in-django-migration.html?utm_source=postgresweekly&utm_medium=email)For a long time Django lacked native migrations, instead developers opted for an add-on library. Now it’s fully integrated but there’s still more you can do than just what is labeled on the box, such as executing custom migrations as highlighted here. Szymon Lipiński#code [pgslice: Easy Postgres Partitioning](https://github.com/ankane/pgslice?utm_source=postgresweekly&utm_medium=email)Works for both new and existing tables, with no downtime and minimal app changes. Andrew Kane#code [Stop Applying to Jobs - Let Companies Come To You](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly. Hired.​com#sponsored    

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