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

Postgres Weekly 181   . 

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

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

[Making Charts with Postgres](https://medium.com/@bengarvey/making-charts-with-postgres-5700f4c65cc8?utm_source=postgresweekly&utm_medium=email)This walkthrough shows you how starting with something simple and gradually building on it can help create a common type of time-series report with SQL. Ben Garvey [Unclogging The VACUUM [PDF\]](http://thebuild.com/presentations/pgconfeu-2016-vax.pdf?utm_source=postgresweekly&utm_medium=email)Info-packed slides from a recent talk looking at “everyone’s least-favorite PostgreSQL feature” that’s nonetheless essential to proper database operation. Christophe Pettus [PostgreSQL Primary Key Type Analysis](http://gosimple.me/postgresql-primary-key-type-analysis/?utm_source=postgresweekly&utm_medium=email)Two common ways to go with primary keys are using integers or UUIDs. This post looks at the pros and cons of each with some good data on performance trade-offs. GOSimple [Platinum 24/7 PostgreSQL Support. 15 minute response, 24-hour bug fix – guaranteed.](https://2ndquadrant.com/en/support/support-postgresql/)When the unexpected happens to your PostgreSQL database only one company provides a guaranteed response rate and guaranteed bug fix within 24 hours. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/aac1429d.png)](https://2ndquadrant.com/en/support/support-postgresql/) [A Curated List of PostgreSQL Software, Libraries & Tools](https://github.com/dhamaniasad/awesome-postgres?utm_source=postgresweekly&utm_medium=email)It’s not new, but this curated list of awesome PostgreSQL software, libraries, tools and resources continues to be updated. Asad Dhamani#code [Rails Implementation of a Ranking System using Window Functions](http://naturaily.com/blog/post/ruby-on-rails-implementation-of-a-ranking-system-using-postgresql-window-functions?utm_source=postgresweekly&utm_medium=email) Patryk Szeliga#tutorial [Implement an Early Warning System for Transaction ID Wraparound in Amazon RDS for PostgreSQL](https://aws.amazon.com/blogs/database/implement-an-early-warning-system-for-transaction-id-wraparound-in-amazon-rds-for-postgresql/?adbsc=social_20161031_67402216&adbid=793131047848321024&adbpl=tw&adbpr=66780587&utm_source=postgresweekly&utm_medium=email)What you can do to monitor your Amazon RDS for PostgreSQL database’s transaction ID health. Amazon#tutorial [SQL Tabs: A Rich (Open Source) SQL Console for Postgres](http://www.sqltabs.com/?utm_source=postgresweekly&utm_medium=email)An open source cross platform desktop client for Postgresql. Aliaksandr Aliashkevich#tools [pgAdmin3 Long Term Support for PostgreSQL 9.6 Released](https://www.postgresql.org/message-id/CAABt7R6Fzfq-q6%2BP4GC9evHcj_BjHvMhULW2aoEbOPXvpzFmSg%40mail.gmail.com?utm_source=postgresweekly&utm_medium=email) David Rader#tools [DB Doc 3.2 for PostgreSQL Released](https://www.postgresql.org/about/news/1710/?utm_source=postgresweekly&utm_medium=email) PostgreSQL#tools [To Reload or Restart? (with A Test Script)](http://www.openscg.com/2016/10/reload-or-restart/?utm_source=postgresweekly&utm_medium=email)Depending on the change you make to your Postgres setting you may have to fully restart your DB or just reload the config, but it all depends on which setting you’re changing. Scott Mead [Don't love your job? You Should - Try Hired and Find the Right Fit.](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Try Hired today to get multiple job offers and free personalized support in planning your next move. Hired#sponsored    

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