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

Postgres Weekly 190   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 190 — January 18, 2017     

[Two Simple Postgres Tricks to Kickstart Your 2017](http://www.cybertec.at/two-simple-postgres-tips-to-kick-start-year-2017/?utm_source=postgresweekly&utm_medium=email)A look at two useful tricks that, the author claims, even ‘power users find surprising’: disabling JOIN re-ordering and using arrays with LIKE. Kaarel Moppel#opinion [Parallel Indexing in Citus](https://www.citusdata.com/blog/2017/01/17/parallel-indexing-with-citus/?utm_source=postgresweekly&utm_medium=email)Indexes tend to make queries fast, but they come at a cost of write throughput. Read how Citus, a Postgres extension, can help parallelize queries to speed things up. Citus Data [Josh Berkus Retires from the Core Team](http://www.databasesoup.com/2017/01/retiring-from-core-team.html?utm_source=postgresweekly&utm_medium=email)After 14 years, Josh Berkus, long time contributor and core team member, has stepped down from the Postgres core team and wants to encourage fresh leadership for the project. Josh Berkus#news [Bring observability to your database](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeekly)Visualize and alert on system resources, connections, locks, transactions, and indexes for real-time full-stack performance monitoring. Datadog#sponsored[![\](https://copm.s3.amazonaws.com/3821a689.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeekly) [Creating Triggers That Fire When You Create Functions](http://dba.stackexchange.com/questions/160484/how-to-trigger-an-event-when-a-function-is-modified/?utm_source=postgresweekly&utm_medium=email) DBA Stack Exchange#tutorial [Another Couple of Steps On My Backup Crusade](https://blog.hagander.net/another-couple-of-steps-on-my-backup-crusade-235/?utm_source=postgresweekly&utm_medium=email)A number of potential ways to improve your PG backups. Magnus Hagander#opinion [Why Postgres](http://bonesmoses.org/2017/01/13/pg-phriday-why-postgres/?utm_source=postgresweekly&utm_medium=email)_“given the alternatives, and what Postgres really delivers when it’s fully leveraged, I can’t even think of a better commercial RDBMS”_ Shaun M.​ Thomas#opinion [PostgreSQL Inheritance](https://swth.ch/2016/12/03/postgresql-inheritance/?utm_source=postgresweekly&utm_medium=email)Table inheritance if often equated with partitioning in Postgres, but as highlighted here can be used from more traditional CS object inheritance if you so choose. Software Thoughts [PostgreSQL WAL Archiving](https://www.opsdash.com/blog/postgresql-wal-archiving-backup.html?utm_source=postgresweekly&utm_medium=email)Under the covers Postgres is one giant append-only log, which in correct technical terms is the write-ahead-log. Here you can find an overview of what it is and how to work with it. RapidLoop [DreamFactory REST API platform for Postgres](http://go.cooperpress.com/rs/pg190/www.dreamfactory.com/signup)Develop apps faster. DreamFactory automatically turns Postgres into a REST API platform in minutes. DreamFactory#sponsored    

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