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

Postgres Weekly 204   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 204 — April 26, 2017     

[A Look at PostgreSQL 9.6's Parallel Queries](https://blog.rebased.pl/2017/04/24/postgresql-9-6-parallel-queries.html?utm_source=postgresweekly&utm_medium=email)A major feature in 9.6 was the parallel execution of sequential scans, joins and aggregates. Here’s a very high level look at what that means. Tomasz Stachewicz#tutorial [Using R Analytic Functions in PostGIS](http://info.crunchydata.com/blog/r-analytic-functions-in-postgis?utm_source=postgresweekly&utm_medium=email)Combining the power of Postgres, PostGIS and R for measuring vegetation in an area over time. Joe Conway#tutorial [Analyzing PostgreSQL Email Archives with PostgreSQL](https://www.citusdata.com/blog/2017/04/20/analyzing-postgresql-email-archives/?utm_source=postgresweekly&utm_medium=email)Tom Lane is one of the largest contributors to Postgres, this post analyzes some of the Postgres mailing list archives for emails with some fun findings. _(An updated post originally from 2013.)_ Citus Data [Because Your Data Is Your Business](http://www.PGExperts.com)PGX's open source experts provide the database and application skills necessary to solve database problems, accelerate existing applications, refactor infrastructure, and develop new applications. PostgreSQL Experts, Inc.​ #sponsored[![\](https://copm.s3.amazonaws.com/bf274a23.png)](http://www.PGExperts.com) [AWS Opens Access to Preview of PG-Flavored Amazon Aurora](https://aws.amazon.com/about-aws/whats-new/2017/04/announcing-open-preview-of-amazon-aurora-with-postgresql-compatibility/?utm_source=postgresweekly&utm_medium=email)All AWS customers can now use the Postgres-compatible variant of its Amazon Aurora database service. Amazon Web Services, Inc.​ #news [When Autovacuum Does Not Vacuum](https://blog.2ndquadrant.com/when-autovacuum-does-not-vacuum/?utm_source=postgresweekly&utm_medium=email)Autovacuum generally works pretty well and keeps your database healthy and performing quickly, but there are some things that can introduce complications as highlighted here such as long running queries. Tomas Vondra#tutorial [A 'Using Sequences in Postgres' FAQ](http://www.neilconway.org/docs/sequences/?utm_source=postgresweekly&utm_medium=email)Most applications these days use sequences (via serial) without even realizing it. Here’s a great primer on how they work and some of the details about them. Neil Conway#tutorial [Setting Up A Custom Replication Conflict Handler in Postgres](http://www.cybertec.at/custom-replication-handlers-for-postgres-bdr/?utm_source=postgresweekly&utm_medium=email) Kaarel Moppel#tutorial ['int4' vs 'int8' vs UUID vs 'numeric' Performance on Bigger Joins](http://www.cybertec.at/int4-vs-int8-vs-uuid-vs-numeric-performance-on-bigger-joins/?utm_source=postgresweekly&utm_medium=email) Kaarel Moppel#opinion [Pgweb: A Cross-Platform Client for Postgres](https://sosedoff.github.io/pgweb/?utm_source=postgresweekly&utm_medium=email)Built using Go and works on macOS, Linux and Windows. Dan Sosedoff#tools [Kallax: A New Typesafe Postgres ORM for Go](https://blog.sourced.tech/post/kallax/?utm_source=postgresweekly&utm_medium=email)Kallax uses code generation for both type safety and performance. This post also digs into why they felt a new ORM was needed in Go. Miguel Molina#code [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/204) [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