Compression | Postgres.FM 107 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RUclips's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss compression in Postgres - what's available natively, some newer algorithms available in recent versions, some things that would be cool additions, and some extensions that offer compression features.
Here are some links to things they mentioned:
* wal_compression www.postgresql...
* Our episode on WAL and checkpoint tuning postgres.fm/ep...
* Synthetic wal_compression and streaming replication wal size test gitlab.com/pos...
* default_toast_compression www.postgresql...
* ZFS en.wikipedia.o...
* Our episode on TOAST postgres.fm/ep...
* On compression of everything in Postgres (talk by Andrey Borodin) learn.microsof...
* cstore_fdw citusdata.gith...
* Using Hydra columnar columnar.docs....
* About compression in Timescale docs.timescale...
* pg_tier github.com/tem...
* pgBackRest pgbackrest.org/
* WAL-G github.com/wal...
* pg_dump www.postgresql...
* pg_dump compression specifications in PostgreSQL 16 (article by Pablo Glob from Cybertec) www.cybertec-p...
* Our episode on pgvector (with Jonathan Katz) postgres.fm/ep...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.

[@DavidPechCZ]

Hi, I've heard this episode yesterday and I could it literally today (TOAST compression - 2TB table with a single JSONB field). Just thanks guys!

[@NikolaySamokhvalov]

you're welcome!