Posts about Postgres 19

Postgres 19: How Our Advice Has Changed Since We Wrote It

Over the years we have written a lot about how data gets into Postgres, how it sits on disk, and how indexes help you find it again. Some of that advice was written against Postgres 10 or 11. A surprising amount of it is still exactly what we would tell you for the upcoming Postgres 19 release. Functionality described here is based on current betas; minor details may still change before GA. This post revisits Crunchy posts in the “load, storage, indexes, and partitioning” bucket: what we wrote,...