Postgres 19 mostly confirms old advice, with async I/O autoscaling and LZ4 by default
Crunchy's post revisits years of load, indexing, and partitioning advice and finds surprisingly little changed in Postgres 19, which refines proven patterns rather than upending them. The notable shifts: autoscaling async I/O workers, more resilient COPY, LZ4 compression on by default, and JIT disabled by default, so analytical workloads need re-testing after upgrade.