---
title: "This Week's PostgreSQL News (#182)"
publication: "Postgres Weekly"
issue: 182
published_at: "2016-11-09"
canonical_url: "https://postgresweekly.com/issues/182"
---

Postgres Weekly 182   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 182 — November 9, 2016     

[Postgres's 'Autovacuum' is Not the Enemy](https://www.citusdata.com/blog/2016/11/04/autovacuum-not-the-enemy/?utm_source=postgresweekly&utm_medium=email)Autovacuum in Postgres often gets a bad reputation, which is a little unfair. Here’s a look at how autovacuum helps with bloat and some guidance on tuning it. Citus Data [Securing PostgreSQL [PDF\]](http://thebuild.com/presentations/pgconfeu-2016-securing-postgresql.pdf?utm_source=postgresweekly&utm_medium=email)Security is something all apps have to think about. Here’s some good general and Postgres specific guidance on all the things you need to think about as you manage your database. Christophe Pettus#tutorial [A PostgreSQL 9.6 Patch for Instance Level Encryption](http://www.cybertec.at/2016/11/announcing-availability-of-postgresql-instance-level-encryption/?utm_source=postgresweekly&utm_medium=email)The patch automatically stores all the files of a cluster on disk in encrypted format and decrypts blocks as they are read from disk into shared buffers. Cybertec#tools [[Webinar\] What's New in MySQL 8.0 and PostgreSQL 9.6](https://www.vividcortex.com/resources/whats-new-in-mysql-8.0-and-postgresql-9.6?utm_campaign=Postgres%20Weekly&utm_source=email)In this recorded webinar, Baron Schwartz discusses some of the new features and capabilities available in MySQL 8.0 and PostgreSQL 9.6. VividCortex#sponsored[![\](https://copm.s3.amazonaws.com/2ff85b31.png)](https://www.vividcortex.com/resources/whats-new-in-mysql-8.0-and-postgresql-9.6?utm_campaign=Postgres%20Weekly&utm_source=email) [Char(16) Conference: A Business Data Scalability Event in NYC](http://charconference.org/?utm_source=postgresweekly&utm_medium=email)Tickets for the CHAR(16) conference, taking place in New York on December 6, are now available. Use code PGW50 for $50 off your ticket price. Focuses on Postgres. Char Conference#news [Writing a RESTful API with Express and MassiveJS](https://medium.com/trisfera/writing-a-restful-api-with-express-massivejs-465218800c08?utm_source=postgresweekly&utm_medium=email)MassiveJS is a library for working with Postgres in Node. Alexis Hevia#tutorial [A Hands-On Experience with Complex SQL](https://www.youtube.com/watch?v=0koLFAB4lAk&utm_source=postgresweekly&utm_medium=email)Filmed at Keep Ruby Weird 2016. _21 minutes_ Craig Kerstiens#video [PostgreSQL 9.6 Improves Synchronous Replication and More](https://lwn.net/Articles/703473/?utm_source=postgresweekly&utm_medium=email)_“PostgreSQL 9.6 has given users plenty of reasons to upgrade.”_ Josh Berkus#opinion [pg_party: Automatic Date-Range Partitioning Script for PG V9.1+](https://github.com/derkan/pg_party?utm_source=postgresweekly&utm_medium=email) Erkan Durmus#tools [Locking PostgreSQL Shared Memory to Physical RAM](http://theplateisbad.blogspot.com/2016/11/locking-postgresql-shared-memory-to.html?utm_source=postgresweekly&utm_medium=email)A way to avoid decrypted data getting leaked to disk, but encrypting your swap may be better. ergo [Hunting PostgreSQL Bugs with SQLsmith](https://korte.credativ.com/~ase/sqlsmith-talk.pdf?utm_source=postgresweekly&utm_medium=email)Slides from PGConf EU walking through a new tool SQLsmith, what type of testing it provides, and some of the results from using it with Postgres. Credativ [Don't Get Frustrated - Get Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Hired puts the power back in your hands, by having companies apply to you, not the other way around. With Hired you only talk to companies you're interested in. Hired#sponsored    

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