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

Postgres Weekly 170   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 170 — August 17, 2016     

[Actually Understanding Timezones in PostgreSQL](http://blog.untrod.com/2016/08/actually-understanding-timezones-in-postgresql.html?utm_source=postgresweekly&utm_medium=email)Postgres’s support for timezones is one of the best amongst relational databases, but what’s the difference between timestamp and timestamptz? This practical guide lays out the things you need to know. Chris Clark#tutorial [PostgreSQL 9.6 Beta 4 Released](https://www.postgresql.org/about/news/1687/?utm_source=postgresweekly&utm_medium=email)This release contains previews of all of the features which will be available in the final release of version 9.6. postgresql.​org#news [2016-08-11 Security Update Release](https://www.postgresql.org/about/news/1688/?utm_source=postgresweekly&utm_medium=email)The PostgreSQL Global Development Group has released an update to all supported versions, including 9.5.4, 9.4.9, 9.3.14, 9.2.18 and 9.1.23. It’s not as critical as other security releases but you’re still encouraged to upgrade when you can. PostgreSQL#news [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) [postgresql-cpp: A C++11 Port of Postgres](https://github.com/jarulraj/postgresql-cpp?utm_source=postgresweekly&utm_medium=email)Postgres doesn’t generally get ported to other languages, so it’s interesting to see this attempt to port to C++’s C++11 standard. This [community member highlights post](https://petereisentraut.blogspot.com/2013/05/moving-to-c.html) indicated there may be benefits. Joy Arulraj#code [An Easy Way to Use a PostgreSQL Database (and Hstore) from Go](https://github.com/xyproto/simplehstore?utm_source=postgresweekly&utm_medium=email)Hstore is an extension that provides key-value storage capabilities directly in Postgres. This library provides an easy way to use a Postgres database (and the Hstore feature) from Go. Alexander F Rødseth#code [Understand Full-Text Search with Postgres](https://github.com/piotrl/understand-full-text-search?utm_source=postgresweekly&utm_medium=email)Full-text search is powerful in Postgres, but not without a learning curve. This in-depth guide covers about everything you need to know to get up and running with it. Piotr Lewandowski [migra: PostgreSQL Migrations Made Almost Painless](https://github.com/djrobstep/migra?utm_source=postgresweekly&utm_medium=email)It’s like ‘diff’ but for PostgreSQL schemas. Robert Lechte#code [BDR 1.0 (Bi-Directional Replication for PostgreSQL)](http://blog.2ndquadrant.com/bdr-1-0/?utm_source=postgresweekly&utm_medium=email)BDR provides multi-master replication across Postgres 9.4 instances. Craig Ringer#tools [Using State Machines to Run Databases](https://www.citusdata.com/blog/2016/08/12/state-machines-to-run-databases/?utm_source=postgresweekly&utm_medium=email)While not directly about running Postgres, if you want a look at how a large as-a-service offering provides databases at scale this gives you a look. The key under the covers is a state machine, used by both Citus and Heroku Postgres. Citus Data [Stop wasting time - know what you'll earn before the interview](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week Hired.​com#job    

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