Compression

Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with compression features.

Here are some links to things they mentioned:
• wal_compression postgresql.org/docs/current/runtime-config-wal…
• Our episode on WAL and checkpoint tuning postgres.fm/episodes/wal-and-checkpoint-tuning
• Synthetic wal_compression and streaming replication wal size test gitlab.com/postgres-ai/postgresql-consulting/t…
• default_toast_compression postgresql.org/docs/current/runtime-config-cli…
• ZFS en.wikipedia.org/wiki/ZFS
• Our episode on TOAST postgres.fm/episodes/toast
• On compression of everything in Postgres (talk by Andrey Borodin) learn.microsoft.com/en-us/shows/cituscon-an-ev…
• cstore_fdw citusdata.github.io/cstore_fdw
• Using Hydra columnar columnar.docs.hydra.so/concepts/using-hydra-co…
• About compression in Timescale docs.timescale.com/use-timescale/latest/compre…
• pg_tier github.com/tembo-io/pg_tier
• pgBackRest pgbackrest.org
• WAL-G github.com/wal-g/wal-g
• pg_dump postgresql.org/docs/current/app-pgdump.html
• pg_dump compression specifications in PostgreSQL 16 (article by Pablo Glob from Cybertec) cybertec-postgresql.com/en/pg_dump-compression…
• Our episode on pgvector (with Jonathan Katz) postgres.fm/episodes/pgvector

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws for the elephant artwork