---
title: "#205: Logical replication in Postgres 10, and the pg_stat_user_indexes table"
publication: "Postgres Weekly"
issue: 205
published_at: "2017-05-03"
canonical_url: "https://postgresweekly.com/issues/205"
---

Postgres Weekly 205   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 205 — May 3, 2017     

[Why Use Postgres](http://www.craigkerstiens.com/2017/04/30/why-postgres-five-years-later/?utm_source=postgresweekly&utm_medium=email)An anniversary follow-up to [a 2012 post on 'why to use Postgres'](http://www.craigkerstiens.com/2012/04/30/why-postgres/) but now looking at features from the last five years. It provoked [extensive discussion on Hacker News](https://news.ycombinator.com/item?id=14232074). Craig Kerstiens [Logical Replication in Postgres 10](https://blog.2ndquadrant.com/logical-replication-postgresql-10/?utm_source=postgresweekly&utm_medium=email)Logical replication has been one of the more welcomed advancements to Postgres in recent years. Postgres 10 will feature a number of updates to it. Get a primer of what it is, and why you would use it. Petr Jelinek [The In-Progress Draft of Postgres 10's Release Notes](https://www.postgresql.org/docs/devel/static/release-10.html?utm_source=postgresweekly&utm_medium=email)Postgres 10 isn’t quite here yet, but it’s starting to take a pretty close-to-final form. Take an early look at the (still in progress) release notes. postgresql.​org [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/a0f6649e.jpg)](https://2ndquadrant.com/en/resources/bdr/) [Deep Dive Into Postgres Stats: pg_stat_user_indexes](http://blog.postgresql-consulting.com/2017/05/deep-dive-into-postgres-stats.html?utm_source=postgresweekly&utm_medium=email)Continuing a great series on Postgres stats, this takes a quick look at an index related stats table, and links to some handy queries for things such as [finding unused indexes](https://wiki.postgresql.org/wiki/Index_Maintenance#Index_size.2Fusage_statistics). Alexey Lesovsky [Postgres Tips for Rails Developers](https://www.citusdata.com/blog/2017/04/28/postgres-tips-for-rails/?utm_source=postgresweekly&utm_medium=email)A recap of the best Rails-related PostgreSQL tips that Citus shared at RailsConf. Citus Data [Creating a Postgres Container with Default User and Password](https://medium.com/@beld_pro/quick-tip-creating-a-postgresql-container-with-default-user-and-password-8bb2adb82342?utm_source=postgresweekly&utm_medium=email)Use Docker for the rest of your local dev and want to set up Postgres the same way? Here’s a quick tutorial on getting things running. Beld [What You Need To Know About SQL's 'GROUP BY'](https://periscopedata.com/blog//everything-about-group-by.html?utm_source=postgresweekly&utm_medium=email)GROUP BY is used so often in SQL that it pays to understand it well. Periscope [The Big Old Reliable Elephant: Talking About Postgres with Craig Kerstiens](https://notamonadtutorial.com/the-big-old-reliable-elephant-talking-about-postgres-with-craig-kerstiens-a07ddec3e460?utm_source=postgresweekly&utm_medium=email)An interview with Craig Kerstiens on the benefits of Postgres over other SQL databases. Federico Carrone [ZomboDB: Integrating Postgres and Elasticsearch](https://www.zombodb.com/?utm_source=postgresweekly&utm_medium=email)ZomboDB is an extension to Postgres that allows you to directly use Elasticsearch indexes from within Postgres. It’s got a new website and look and is worth taking a look at if you use both. ZomboDB#tools [Linux cloud hosting starting at 1GB of RAM for $5/mo.](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. linode#sponsored    

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