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

Postgres Weekly 132   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 132 — November 18, 2015     

[awesome-postgres: A Curated List PostgreSQL Software, Libraries, Tools and Resources](https://github.com/dhamaniasad/awesome-postgres?utm_source=postgresweekly&utm_medium=email)A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql. Asad Dhamani#code [Parallel Sequential Scan is Committed](http://rhaas.blogspot.co.uk/2015/11/parallel-sequential-scan-is-committed.html?utm_source=postgresweekly&utm_medium=email)“I’ve just committed the first version of parallel sequential scan to PostgreSQL’s master branch, with a view toward having it included in the upcoming PostgreSQL 9.6 release.” Robert Haas [Generated Primary and Foreign Keys for Distributed Databases](http://www.enterprisedb.com/postgres-plus-edb-blog/dick-dowdell/generated-primary-and-foreign-keys-distributed-databases?utm_source=postgresweekly&utm_medium=email)In the world of monolithic applications serial integers work just fine, as long as you don’t exhaust your set of IDs. But as soon as you go across multiple distributed databases there’s other concerns to think about. Dick Dowdell [Free Network Analyzer Tool for PostgreSQL](http://www.vividcortex.com/resources/network-analyzer-for-postgres/?utm_)VividCortex’s network traffic analyzer tool is an easy-to-use way to gain insight into your PostgreSQL server’s activity. Built for PostgreSQL servers running on Linux operating systems, it is a non-intrusive, safe way to understand your query workload. It's fast, secure, and private. Vivid Cortex#sponsored[![\](https://copm.s3.amazonaws.com/947cc9dd.png)](http://www.vividcortex.com/resources/network-analyzer-for-postgres/?utm_) [Rails Validations vs Postgres Check Constraints](http://naildrivin5.com/blog/2015/11/15/rails-validations-vs-postgres-check-constraints.html?utm_source=postgresweekly&utm_medium=email)When it comes to data integrity and validation you can’t be too safe, and you should definitely have it at the lowest level. Not all databases provide that, but Postgres does and here how you can see it play with a good approach to constraints at every level of your app. David Bryant Copeland [PostgreSQL on SSD - 4KB or 8KB Pages?](http://blog.pgaddict.com/posts/postgresql-on-ssd-4kb-or-8kB-pages?utm_source=postgresweekly&utm_medium=email) Tomas Vondra [Trigram Searches in Rails and PostgreSQL for Autocomplete](http://www.sitepoint.com/awesome-autocomplete-trigram-search-in-rails-and-postgresql/?utm_source=postgresweekly&utm_medium=email)An amazing guide to educate you on trigrams (so you can sound more intelligent when you drop the term in a meeting), search, and how to apply it all directly in a Rails app. SitePoint#tutorial [pg_grants_manager: PostgreSQL Automated Grants Managment](https://github.com/shereshevsky/pg_grants_manager?utm_source=postgresweekly&utm_medium=email)If you manage a database and want to have that tie into your collection of users take a look at this tool to help you map users in your own system directly to PG users. github.​com#code [yoke: Postgres High-Availability Cluster with Auto-failover and Automated Cluster Recovery](https://github.com/nanopack/yoke?utm_source=postgresweekly&utm_medium=email) GitHub#code [Wait Interface on Postgres](https://simply.name/pg-stat-wait.html?utm_source=postgresweekly&utm_medium=email)Postgres captures a ton of statistics of what’s going on under the covers, sometimes getting at those to know exactly what’s happening is harder than you’d like. This wait interface makes it easy to introspect across all your sessions, great for monitoring and operations. simply.​name [Full-Stack Engineer at VTS (New York, NY)](http://grnh.se/bi54js?utm_source=postgresweekly&utm_medium=email)We’re looking to grow our engineering team beyond 20 as we redefine antiquated software in commercial real estate. If building out new products and setting the foundation for a more efficient system sounds appealing to you, we should talk. VTS.​COM#job [Go Get Hired, With Hired](https://hired.com/?utm_source=postgresweekly&utm_medium=email&utm_campaign=q4_15-petercooperpress&utm_term=job&utm_content=111815-go)Never had a company apply to you? Well now you can when you sign up at Hired.com to receive your personalized offer, base salary and total compensation up front. Hired.​com#job    

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