The second alpha release of PostgreSQL 9.5 is available for download with numerous bugs and issues fixed since the first alpha. The final release will be late in the year.

Postgres 9.5 is just around the corner, and if you want to hit the ground running with all the new features such as upsert, here’s a great run down with hands on examples. (77 page PDF)

VividCortex is the easiest, safest, and most detailed way to monitor PostgreSQL. Unlike other tools that just capture a few status metrics, VividCortex measures every query, every process, and every metric on your entire system, down to the microsecond to improve performance.

If you care at all about you data, you want to have a solid story around your backups. If you’re on Heroku Postgres then it can become quite easy for you with PGBackups, here’s a walkthrough in what you need to know

In response to Oracle’s ‘stop checking our code for vulnerabilities’ debacle, Postgres’ Josh Berkus openly invites people to security test Postgres.

The replication story of Postgres continues to get better and better, with primitives rapidly improving. Here’s on of the first to land in Postgres 9.6, though we’ve got a while before we’ll see it land if you’re operating Postgres this is worth a look.

It should go without saying that using two different database systems in different environments is a recipe for trouble, but Michael explains why.

Want to sample the stats in your Postgres to get a rough count of records? There’s a great way to do that… just on some small tables you might be a bit surprised by the results, here’s the background on how it works to explain why.

Many web frameworks have rich ORMs, some of which support Postgres specific features, some less so. For many though Go is much more direct in how you access Postgres, but this should help you get pointed in the right direction.

Cstore the open source columnar (which popular databases such as Vertical and Redshift are as well) extension has a new update. The update is primarily around better I/O and disk usage.

Our product teams are multidisciplinary with design, frontend and backend engineering combined. While specialisation is important, we dislike pigeonholing. Great engineers pick the best tools to build the best product.