POSTGRES 19: HOW OUR ADVICE HAS CHANGED SINCE WE WROTE IT

Summary from the TLDR Data newsletter

Postgres 19 mostly strengthens proven practices rather than changing them, building on async I/O with autoscaling workers while adding more resilient COPY, LZ4 compression by default, improved indexing, and smoother partition management. The core advice remains the same: use COPY for bulk loads, model hot data structurally, choose indexes carefully, and partition primarily for lifecycle management.