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

Postgres Weekly 198   . 

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

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

[Google Cloud SQL for PostgreSQL](https://cloud.google.com/sql/docs/postgres/?utm_source=postgresweekly&utm_medium=email)Now in beta, Google Cloud SQL has added support for PostgreSQL. Make sure to give it a try. Google Cloud Platform#news [Parallel Query v2: What Is (and Might Be) Coming in Postgres 10](http://rhaas.blogspot.com/2017/03/parallel-query-v2.html?utm_source=postgresweekly&utm_medium=email)Postgres 10 is starting to come together and there are a lot of exciting changes. At the top of the list there’s a number of Parallelism improvements, some already committed and some hopefully still to be committed. Robert Haas [How to Scale PostgreSQL on AWS](https://www.citusdata.com/blog/2017/03/10/how-to-scale-postgresql-on-aws/?utm_source=postgresweekly&utm_medium=email)Citus extends Postgres to easily shard your data. They launched a managed service on top of AWS a year ago and here’s a number of the learnings from running a database as a service. Citus Data [[Case Study\] Sales Loft](https://www.vividcortex.com/resources/salesloft?utm_campaign=Postgres%20Weekly&utm_source=ppc)Read this case study to hear how a sales development software company was able to decrease its use of temporary tables by 90% VividCortex#sponsored[![\](https://copm.s3.amazonaws.com/90fb5add.png)](https://www.vividcortex.com/resources/salesloft?utm_campaign=Postgres%20Weekly&utm_source=ppc) [Acra: An Open Source Postgres Protection Suite](https://github.com/cossacklabs/acra?utm_source=postgresweekly&utm_medium=email)Tools to secure PG databases in distributed environments. Selectively encrypt records and detect potential intrusions and SQL injections. Mongo & MySQL support promised soon. [More here.](https://www.cossacklabs.com/acra/) Cossack Labs#tools [How to Deploy a HA Postgres Cluster on Kubernetes](https://medium.com/@SergeyNuzhdin/how-to-deploy-ha-postgresql-cluster-on-kubernetes-3bf9ed60c64f?utm_source=postgresweekly&utm_medium=email) Sergey Nuzhdin [A Multi-Tenant Sharding Tutorial](https://www.citusdata.com/blog/2017/03/09/multi-tenant-sharding-tutorial/?utm_source=postgresweekly&utm_medium=email) Citus Data [Getting Started with JSONB in Postgres](http://www.craigkerstiens.com/2017/03/12/getting-started-with-jsonb-in-postgres/?utm_source=postgresweekly&utm_medium=email)Some basics to using Postgres’s powerful binary JSON datatype. Craig Kerstiens [Simple and Manual Sharding on Postgres](http://www.3manuek.com/postgresmanualsharding?utm_source=postgresweekly&utm_medium=email)Combining foreign table inheritance with the postgres_fdw extension. Emanuel Calvo [Metrics Maven: Exponentially Weighted Moving Average in PostgreSQL](https://compose.com/articles/metrics-maven-calculating-an-exponentially-weighted-moving-average-in-postgresql/?utm_source=cooper&utm_medium=newsletter&utm_content=postgresql)In this episode of our MM series we'll show you how to calculate an exponentially weighted moving average. Compose#sponsored [Modifying Files Outside of PG While Maintaining Transaction Safety](https://hackernoon.com/modifying-files-stored-outside-of-postgresql-while-maintaining-full-transaction-safety-and-d8b55327e679?utm_source=postgresweekly&utm_medium=email#.cds1bsopy)_“What to do when things get too big to be stored inline in the database but we still want all that juicy transaction safety and read-write locks without building your own gatekeeping solution?”_ Matthaus Woolard [Wait Event Reporting in 9.6](http://momjian.us/main/blogs/pgblog/2017.html?utm_source=postgresweekly&utm_medium=email#February_28_2017)The wait_event_type and wait_event columns on the pg_stat_activity view make it possible to find what’s causing query delays. Bruce Momjian [Queues in Postgres [PDF\]](https://www.pgcon.org/2016/schedule/attachments/414_queues-pgcon-2016.pdf?utm_source=postgresweekly&utm_medium=email) Thomas Munro    

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