{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Compression","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/067bd886\"></iframe>","width":"100%","height":180,"duration":2716,"description":"Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with compression features.\n \nHere are some links to things they mentioned:\nwal_compression https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-COMPRESSION\nOur episode on WAL and checkpoint tuning https://postgres.fm/episodes/wal-and-checkpoint-tuning\nSynthetic wal_compression and streaming replication wal size test https://gitlab.com/postgres-ai/postgresql-consulting/tests-and-benchmarks/-/issues/11\ndefault_toast_compression https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-DEFAULT-TOAST-COMPRESSION \nZFS https://en.wikipedia.org/wiki/ZFS\nOur episode on TOAST https://postgres.fm/episodes/toast\nOn compression of everything in Postgres (talk by Andrey Borodin) https://learn.microsoft.com/en-us/shows/cituscon-an-event-for-postgres-2023/on-compression-of-everything-in-postgres-citus-con-2023\ncstore_fdw https://citusdata.github.io/cstore_fdw/\nUsing Hydra columnar https://columnar.docs.hydra.so/concepts/using-hydra-columnar\nAbout compression in Timescale https://docs.timescale.com/use-timescale/latest/compression/about-compression/\npg_tier https://github.com/tembo-io/pg_tier\npgBackRest https://pgbackrest.org/\nWAL-G https://github.com/wal-g/wal-g\npg_dump https://www.postgresql.org/docs/current/app-pgdump.html\npg_dump compression specifications in PostgreSQL 16 (article by Pablo Glob from Cybertec) https://www.cybertec-postgresql.com/en/pg_dump-compression-specifications-postgresql-16/\nOur episode on pgvector (with Jonathan Katz) https://postgres.fm/episodes/pgvector \n\n~~~\nWhat did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!\n\n~~~\nPostgres FM is produced by:\nMichael Christofides, founder of pgMustard\nNikolay Samokhvalov, founder of Postgres.ai\n\nWith special thanks to:\nJessie Draws for the...","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}