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

Postgres Weekly 188   . 

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

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

We hope you had a good time over the holidays and we look forward to an exciting year for Postgres in 2017. We're looking at updating the design and approach of the newsletter a little soon, so if you have any suggestions or feedback, just hit reply and we'll take it all into account :-) 

[Controlling Autovacuum](http://momjian.us/main/blogs/pgblog/2017.html?utm_source=postgresweekly&utm_medium=email#January_3_2017)Autovacuum performs recycling of old rows and updates optimizer statistics but can slow things down while it runs. Bruce looks at how to encourage autovacuum to run more during idle periods and less during busy moments. Bruce Momjian 

[Generating YouTube-Like IDs Using PL/V8 and Hashids](https://blog.abevoelker.com/2017-01-03/generating-youtube-like-ids-in-postgres-using-plv8-and-hashids/?utm_source=postgresweekly&utm_medium=email)An alternative to exposing numeric IDs or lengthy UUIDs. There’s also a native Postgres extension to do this called pg_hashids. Abe Voelker 

[Solving a Classic Puzzle using Postgres and Advanced SQL](https://explainextended.com/2016/12/31/happy-new-year-8/?utm_source=postgresweekly&utm_medium=email)Love puzzles and got quite a bit of time on your hands? This is a fascinating journey. Quassnoi 

[Real-time Postgres performance monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgressWeekly)Graph and correlate hits, commits, and deadlocks (and more!) with metrics and events from the rest of your infrastructure. Start monitoring in minutes. Datadog#sponsored — [![\](https://copm.s3.amazonaws.com/c70dde6b.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgressWeekly) 

[Postgres 10 Highlight - Checkpoint Skip Logic](http://paquier.xyz/postgresql-2/postgres-10-checkpoint-skip/?utm_source=postgresweekly&utm_medium=email) Michael Paquier 

[How to Generate A Pivoted CROSS JOIN Where The Resulting Table Definition Is Unknown](http://dba.stackexchange.com/questions/159280/how-do-i-generate-a-pivoted-cross-join-where-the-resulting-table-definition-is-u/159339?utm_source=postgresweekly&utm_medium=email)An interesting question and set of answers that looks into using Postgres’ ‘crosstab’ function as well as other approaches. Stack Exchange 

[How to Protect Your Data with Constraints](http://nathanmlong.com/2016/01/protect-your-data-with-postgresql-constraints/?utm_source=postgresweekly&utm_medium=email) Nathan Long 

[Why is array_agg() Slower than the Plain SQL Equivalent?](http://dba.stackexchange.com/questions/159710/why-is-array-agg-slower-than-the-sql-equivalent?utm_source=postgresweekly&utm_medium=email) Stack Exchange 

[An Introduction to Stolon: Cloud Native Postgres High Availability](https://sgotti.me/post/stolon-introduction/?utm_source=postgresweekly&utm_medium=email)A manager for providing high availability Postgres using streaming replication. Simone Gotti#tools 

[SQLBoiler: Generate a Go(lang) ORM Tailored to Your Schema](https://github.com/vattle/sqlboiler?utm_source=postgresweekly&utm_medium=email) Vattle#tools 

[PgRebase: Manage Functions/Triggers/Types/Views As Plain Files](https://github.com/oelmekki/pgrebase?utm_source=postgresweekly&utm_medium=email) Olivier El Mekki#tools 

[pg_themis: Postgres Extension for Encryption/Decryption with Themis](https://github.com/cossacklabs/pg_themis?utm_source=postgresweekly&utm_medium=email)[Themis](https://github.com/cossacklabs/themis) is a high-level cross-language general cryptography library. Cossack Labs#code 

[DreamFactory open source REST API platform](https://www.dreamfactory.com/signup)Develop apps faster. DreamFactory automatically turns any database 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/188) [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