SQL best practices – don’t compare count(*) with 0

Case study: optimization of weirdly picked bad plan

SQL/JSON is here! (kinda “Waiting for Pg 17”)

Waiting for PostgreSQL 14: SEARCH and CYCLE clauses

Waiting for PostgreSQL 15 – Add support for MERGE SQL command

Waiting for PostgreSQL 15 – Add UNIQUE null treatment option

How much disk space you can save by using INT4/INT instead of INT8/BIGINT?

PostgreSQL 15: default permissions for everyone is now restricted to db owner

Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses

PostgreSQL's Explain Analyze Made Readable

Why upgrade PostgreSQL?

Why is UPSERT so complicated?

PostgreSQL 9.5 will have native sharding