Here’s a collection of a few simple but very handy Postgres features that will be useful for anyone who works with Postgres frequently.

pgbench is the norm when it comes to performance testing your Postgres database. Here you can learn how to use it to simulate a more realistic workload to assist with tuning your database.

Being able to define quorum sets of synchronous standbys provides more flexibility in some availability scenarios.

Identifying database security vulnerabilities is the first step towards improving your infrastructure so that you don't fall victim to breach. A Security Audit with 2ndQuadrant evaluates and provides recommendations for the security of your database.

Early registration for this years PGConf US, taking place in March near NYC, is now open.

Simplifies the process of setting up databases with high availability and scalability requirements.

Window functions allow you to interact between rows in Postgres. For analytics they’re extremely powerful, and there’s a number of functions you can use with them. Here’s an overview of a few valuable ones and the differences.

Indexing is powerful in Postgres, with types, conditional, and functional indexes. While they can give you great performance, understanding the details can help you know what you’re getting. Here's a great read on multi-column ones and how they work.

Why don’t we just use Postgres’ spatial functions? Paul Ramsey looks at the history.

kill -9 on Postgres will dramatically slow down its restart time.

A minor release of the backup and recovery manager tool Barman, fixing a few bugs.

Most people connect to Postgres with a standard username/password, but there’s a few more options. This highlights some of the flexibility of authentication you can use with PostgreSQL.

Spoiler: Almost certainly not, but it was an interesting question.

High-level sessions on growing an engineering organization with effective DevOps, going serverless and more.