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.
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.
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 indicated there may be benefits.
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.