Skip to content- Sources: primary
- Summary: PlanetScale shows TOAST triggers above 2,032 bytes per row and explains the 4 KB pglz window against the 64 KB LZ4 window. On 10,000 JSON orders pglz produced 19 MB against 24 MB for LZ4, while LZ4 loaded faster. For 200-character previews of 1 MB values pglz needed 301 page lookups against 6,234 for LZ4, and EXTERNAL storage made mid-value bytea reads about 70 times faster than LZ4.
- Why it matters: Upgrading to Postgres 19 changes compression for new values, so tables with prefix reads or random-access bytea may need an explicit COMPRESSION or STORAGE setting.