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

Postgres Weekly 197   . 

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

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

[Simple and Awesome Database Tricks](https://www.youtube.com/watch?v=N08NHsyaoKM&utm_source=postgresweekly&utm_medium=email)A talk from RubyConf AU 2017 that focuses on Postgres-oriented tips and tricks, including PostGIS and explain plans. Barrett Clark#video [Autovacuum Tuning Basics](https://blog.2ndquadrant.com/autovacuum-tuning-basics/?utm_source=postgresweekly&utm_medium=email)A common source of performance related problems is in Postgres’s ‘autovacuum’ system. Here’s a look at the basics of tuning it for your use case. Tomas Vondra#tutorial [The How and Why of Descending Indexes](http://momjian.us/main/blogs/pgblog/2017.html?utm_source=postgresweekly&utm_medium=email#February_27_2017)‘CREATE INDEX’ lets you specify ASC or DESC for each column being indexed, but why? A practical example here. Bruce Momjian#tutorial [Barman: Backup Strategy and Disaster Recovery Manager for Critical Databases](https://2ndquadrant.com/en/resources/barman/)Does your company have a disaster recovery plan in place? More importantly, when's the last time you tested it? Don't risk experiencing severe data loss or down-time. Act pre-emptively & discover how Barman can help secure your critical databases. 2ndQuadrant PostgreSQL Products#sponsored[![\](https://copm.s3.amazonaws.com/2a94f98f.png)](https://2ndquadrant.com/en/resources/barman/) [A Look at pg_stat_bgwriter](http://blog.postgresql-consulting.com/2017/03/deep-dive-into-postgres-stats.html?utm_source=postgresweekly&utm_medium=email)A single row that shows stats about the background writer process’s activity. Alexey Lesovsky [Parsing Addresses in PostgreSQL using the 'address_standardizer' Extension](http://dba.stackexchange.com/questions/165915/how-do-i-parse-addresses-in-postgresql/165916?utm_source=postgresweekly&utm_medium=email#165916)A project from the PostGIS project that can break an address into its component parts. Stack Exchange [Basic Kafka and Postgres Integration with Kafkacat and COPY](http://www.3manuek.com/kafkacatandcopypg?utm_source=postgresweekly&utm_medium=email) Emanuel Calvo [Using pg_dumpall with AWS RDS Postgres](http://www.thatguyfromdelhi.com/2017/03/using-pgdumpall-with-aws-rds-postgres.html?utm_source=postgresweekly&utm_medium=email) Robins Tharakan [Deploying PostgreSQL Clusters using StatefulSets](http://blog.kubernetes.io/2017/02/postgresql-clusters-kubernetes-statefulsets.html?utm_source=postgresweekly&utm_medium=email)How to build a PostgreSQL cluster using Kubernetes’ new [StatefulSets](https://kubernetes.io/docs/concepts/abstractions/controllers/statefulsets/)feature. Jeff McCormick [A Simple Guide to Fulltext Search in Postgres](https://lo.calho.st/databases/an-idiots-guide-to-fulltext-search-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Doing `LIKE %` queries for searches in your app? A better approach is Postgres’s full-text search functionality, as explained here. Travis Mick [Use all the Databases with GraphQL](https://www.compose.com/articles/use-all-the-databases-part-1/?utm_source=cooper&utm_medium=newsletter&utm_content=postgresql)Loren Sands-Ramshaw, author of GraphQL: The New REST, shows how to use GraphQL with multiple databases. Compose#sponsored [How to Use User-Defined Partition Names in pg_pathman](https://zilder.github.io/blog/2017/03/01/user-defined-partition-names-in-pg_pathman/?utm_source=postgresweekly&utm_medium=email)[pg_pathman](https://github.com/postgrespro/pg_pathman) is a set of partitioning tools. Ildar Musin [Forming a PostgreSQL Cluster Within Kubernetes](https://medium.com/@dpaunin/postgresql-cluster-into-kubernetes-cluster-f353cde212de?utm_source=postgresweekly&utm_medium=email) Dmitriy Paunin [Easily Capturing 'Change Data' - a Postgres Game Changer?](https://www.openscg.com/2017/03/postgresql-game-changer-change-data-capture/?utm_source=postgresweekly&utm_medium=email) Jim Mlodgenski [migra: PostgreSQL Migrations Made Almost Painless](https://github.com/djrobstep/migra?utm_source=postgresweekly&utm_medium=email)It’s like ‘diff’ but for PostgreSQL schemas. Robert Lechte    

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