# Postgres 19

Published articles for Postgres 19.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## 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.

## Postgres 19 Compression: from pglz to LZ4

DevFeed: [Postgres 19 Compression: from pglz to LZ4](<https://devfeed.tech/articles/postgres-19-compression-from-pglz-to-lz4-14481.md>)

Original publisher: [Read original article](<https://www.crunchydata.com/blog/postgres-19-compression-from-pglz-to-lz4>)

Author: Christopher Winslett

Published: 2026-07-16T12:00:00Z

Content type: article

Language: en

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

Topics: [Compression](<https://devfeed.tech/topics/compression.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [algorithm](<https://devfeed.tech/tags/algorithm.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [compression](<https://devfeed.tech/tags/compression.md>), [open-source](<https://devfeed.tech/tags/open-source.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>), [speed](<https://devfeed.tech/tags/speed.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

This article explains how PostgreSQL compresses table, TOAST, and index data, and examines the planned Postgres 19 change from pglz to LZ4 as the default TOAST compression algorithm.

### Source excerpt

With Postgres 19 switching the default from pglz to LZ4, this post walks through the compression decision path, storage strategies, and index-size limits that shape real-world behavior.