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

DevFeed: [Postgres 19: How Our Advice Has Changed Since We Wrote It](<https://devfeed.tech/articles/postgres-19-how-our-advice-has-changed-since-we-wrote-it-14482.md>)

Original publisher: [Read original article](<https://www.crunchydata.com/blog/postgres-19-how-our-advice-has-changed-since-we-wrote-it>)

Author: Christopher Winslett

Published: 2026-08-18T19:00:00Z

Content type: article

Language: en

Sources: [CrunchyData Blog](<https://devfeed.tech/sources/crunchydata-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [JIT](<https://devfeed.tech/topics/jit.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Temporal data](<https://devfeed.tech/topics/temporal-data.md>), [Linux](<https://devfeed.tech/topics/linux.md>)

Tags: [advice](<https://devfeed.tech/tags/advice.md>), [async](<https://devfeed.tech/tags/async.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [index](<https://devfeed.tech/tags/index.md>), [jit](<https://devfeed.tech/tags/jit.md>), [latency](<https://devfeed.tech/tags/latency.md>), [linux](<https://devfeed.tech/tags/linux.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgres-19](<https://devfeed.tech/tags/postgres-19.md>), [production-postgres](<https://devfeed.tech/tags/production-postgres.md>), [release](<https://devfeed.tech/tags/release.md>), [storage](<https://devfeed.tech/tags/storage.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

## AI overview

This article revisits earlier Crunchy Data guidance on loading, storage, indexes, and partitioning for the upcoming Postgres 19 release. It explains which changes in Postgres 18 and 19 affect that advice, including asynchronous I/O, parallel maintenance, BRIN and skip-scan behavior, partition operations, and JIT being disabled by default. The details are based on current betas and may change before general availability.

## Source excerpt

Revisiting Crunchy posts on COPY, TOAST, BRIN, covering indexes, and partitioning: what we said then, which Postgres versions changed the story, and what we recommend on Postgres 19.