Choosing a PostgreSQL data type looks like a small decision until the table reaches hundreds of millions of rows. Here is how types affect storage, indexes and query performance, and how to choose well.

JIT compilation can make PostgreSQL queries faster, or much slower. Two side-by-side tests show when it pays off, when it backfires, and how to check your own workload.

Why does a PostgreSQL table grow when the row count stays the same? This beginner’s guide uses pageinspect to show how MVCC and dead tuples cause table bloat.