JSONB, or binary JSON, is the best improvement to come to Postgres in several years. Just as valuable are all the operators that come with it, here’s a rundown of them.

pg_stat_activity provides a SQL-accessible view of Postgres’ various processes and user activity.

Slides from a PGConf Silicon Valley talk looking at how Postgres can be made PCI compliant (so that payment card processors won’t hate or block you).

Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. 14 day unlimited trial.

Hyperloglog is a very interesting algorithm and you can have an extremely efficient version directly in Postgres. And if you’re not up for building and pulling in your own extensions here’s a raw SQL implementation of it.

The pg_paxos extension demonstrates how the Paxos algorithm can be used for fault-tolerant, consistent table replication in Postgres.

Common table expressions or more commonly known as WITH clauses are very useful in Postgres. Not only can you do recursive queries, they also make simpler queries more readable.

Vacuum and Autovacuum have gotten much better over the years in Postgres, but their behavior can be misunderstood. Here’s an up to date slidedeck that walks you through the ins and outs.

Companies are looking to hire someone with your skillset. Stop applying and let companies come to you with offers, which include salary and other benefit information upfront.