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.
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
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.
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.
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.
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.
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
