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

Postgres Weekly 164   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 164 — July 6, 2016     

[WAL-based Estimates For When a Record Was Changed](http://blog.endpoint.com/2016/07/wal-based-estimates-for-when-record-was.html?utm_source=postgresweekly&utm_medium=email)A way to approximate an ‘updated_at’ timestamp column for tables when you didn’t have one in the first place. Josh Williams#tutorial [EXCEPTIONal Performance](http://bonesmoses.org/2016/07/01/pg-phriday-exceptional-performance/?utm_source=postgresweekly&utm_medium=email)A look at the performance implications when using EXCEPTION blocks in PL/pgSQL. Shaun M.​ Thomas [Working With Case Insensitive Data (video)](https://www.pgcasts.com/episodes/8/working-with-case-insensitive-data/?utm_source=postgresweekly&utm_medium=email)A 4 minute screencast on working with case insensitive data in Postgres. PG Casts#video [RAM increased across all plans. Now get 2GB of RAM for only $10/mo.](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly)Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code`POSTGRES20` Linode#sponsored[![\](https://copm.s3.amazonaws.com/9925772c.png)](http://welcome.linode.com/postgres-weekly?utm_source=cooperpress&utm_medium=primary&utm_term=go&utm_campaign=postgres-weekly) [PostgresOpen 2016: September 13-15 in Dallas, Texas](https://postgresopen.org/events/sessions/pgopen2016/?utm_source=postgresweekly&utm_medium=email)Another Postgres conference is is just around the corner, and its schedule is now up. Other upcoming events include [PG Conf EU in Estonia](http://2016.pgconf.eu/) and [PG Conf SV in Silicon Valley](http://www.pgconfsv.com/). PostgresOpen#news [Postgres: The Bits You Haven't Found](https://postgres-bits.herokuapp.com/?utm_source=postgresweekly&utm_medium=email)A golden oldie slidedeck from the 9.3 era packed with interesting bits and pieces. Peter van Hardenberg [The Evolution of Fault Tolerance in PostgreSQL](http://blog.2ndquadrant.com/evolution-of-fault-tolerance-in-postgresql/?utm_source=postgresweekly&utm_medium=email) Gulcin Yildirim#tutorial [PostgreSQL Maestro 16.6 Released](https://www.postgresql.org/about/news/1679/?utm_source=postgresweekly&utm_medium=email)A powerful Windows Postgres admin and development GUI. Now with support for 9.6. postgresql.​org#tools [Compare: A Postgres Comparison and Deployment Tool](http://www.postgrescompare.com/?utm_source=postgresweekly&utm_medium=email)A tool to help you look into your Postgres performance. Postgres Compare looks at changes you’ve made to your database and guides you on further adjustments. Currently in beta behind a sign up. Postgres Compare#tools [pg-check-cert: Simple CLI Tool to Monitor Postgres SSL Certificates](https://github.com/chr4/pg-check-cert?utm_source=postgresweekly&utm_medium=email) Chris Aumann#tools [The Easiest Way to Find a Job](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-go&utm_content=easiest&utm_campaign=q3-16-postgresweekly&utm_location=us)Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. [Try it today.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-go&utm_content=easiest&utm_campaign=q3-16-postgresweekly&utm_location=us) Hired.​com#sponsored    

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