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

Postgres Weekly 171   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 171 — August 24, 2016     

[Postgres The Good Parts: Arrays](http://blog.ryankelly.us/2016/08/21/postgres-the-good-parts-arrays.html?utm_source=postgresweekly&utm_medium=email)Postgres is packed with great datatypes, one of them that may not get quite as much attention as JSONB is the Array type. This post starts with the basics then digs into some more advanced uses and operators of it to make things more practical. Ryan Kelly [Problems with Concurrent Postgres Indexes (and How to Solve Them)](https://medium.com/carwow-product-engineering/problems-with-concurrent-postgres-indexes-and-how-to-solve-them-c57f7656c852?utm_source=postgresweekly&utm_medium=email)If you’re not familiar with concurrent indexing in Postgres, first off you should give them a look. Second, you should know they’re not without their issues which are walked through here. Ken Alex Fassone#tutorial [Frustrating Proprietary Licences Pushing Moves to PostgreSQL](https://joinup.ec.europa.eu/node/154819?utm_source=postgresweekly&utm_medium=email)Several European institutions have cited complex licences from their traditional proprietary suppliers as an important reason to deploy PostgreSQL instead. Adrian Offerman#news [Find Your Perfect Company Match](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies. Hired.​com#sponsored[![\](https://copm.s3.amazonaws.com/428e0985.png)](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly) [Announcing Citus 5.2](https://www.citusdata.com/blog/2016/08/19/announcing-citus-52/?utm_source=postgresweekly&utm_medium=email)Citus 5.2 is out which is an extension which makes it simple to shard your database, allowing you to scale out. The 5.2 release includes better ORM support, broader SQL coverage, and improved transactional semantics on a single shard. Citus Data#news [Optimising PostgreSQL Database Queries using Indexes](http://blog.redpanthers.co/optimising-postgresql-database-query-using-indexes/?utm_source=postgresweekly&utm_medium=email)An intro to indexes, what they are, how to create, as well as some more customized approaches. All of this with a focus on improving your apps performance. RedPanthers#tutorial [Weighted Random Sampling with Postgres](http://www.marcosantoni.com/2016/08/23/weighted-random-sampling-with-postgresql/?utm_source=postgresweekly&utm_medium=email)Generating random data isn’t too hard, but generating a realistic sampling based on some weighting can be. This post walks you through how to do this in SQL, perfect for fake datasets. Marco Santoni#tutorial [Walbouncer: A Proxy for Selective PostgreSQL Replication](http://www.cybertec.at/2016/08/walbouncer-refreshed-a-proxy-for-selective-postgresql-physical-replication/?utm_source=postgresweekly&utm_medium=email)With support for Postgres 9.5, Walbouncer is a standalone replication proxy, enabling selective replication by forwarding data only for specific databases/tablespaces to the connected replicas. Kaarel Moppel#tools [Send slow queries to Slack, PagerDuty, HipChat, or/and email](https://papertrailapp.com/?utm_source=cooperpress&utm_medium=email&utm_term=postgres&utm_campaign=postgres-20160824)Make the most of `log_min_duration_statement`. Get notified instantly or receive a daily summary (free). Papertrail#tools#sponsored [JsQuery: JSON Query Language with GIN Indexing Support](https://github.com/postgrespro/jsquery?utm_source=postgresweekly&utm_medium=email) Postgres Professional#code    

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