The next key release of Postgres is here and ready to roll. Key features include parallel queries, faster autovacuum, phrase searching in full-text search, and many performance improvements. Release notes here.
Corruption is inevitable, and given a long enough timespan it can occur on many databases. pg_healer is a new extension that monitors for corruption and helps repair it.
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 replication is a staple of any production installation, but there’s a number of options. This great guide from OpenSCG lays out the options and things you should think through as you decide which to use.
PostGIS 2.3 is already here with support for Postgres 9.6. The best part is it already leverages possibly the best feature in 9.6: parallelism. If you’re using PostGIS consider giving it a try.
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.