Episode
On compression of everything in Postgres | Citus Con 2023
with Andrey Borodin
Video of a conference talk given by Andrey Borodin about the Postgres pglz algorithm to compress TOASTs and full page images in WAL. The talk examines the impact of Postgres features already committed, with lz4 everywhere. In this talk you’ll also learn about the prospects of compression application that are yet to come: protocol compression, temp files compression, WAL compression, and data segments compression.
Also discussed is the so-called “random access compressed file.” Having random write compressed files in the Postgres core would allow many very cool things. Andrey believes this component could increase OLTP performance by a significant multiplier on IO bottlenecked installations.
Andrey Borodin has been hacking on Postgres since 2016. He is an associated professor at Yandex School for Data Analysis and Ural Federal University.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
Video of a conference talk given by Andrey Borodin about the Postgres pglz algorithm to compress TOASTs and full page images in WAL. The talk examines the impact of Postgres features already committed, with lz4 everywhere. In this talk you’ll also learn about the prospects of compression application that are yet to come: protocol compression, temp files compression, WAL compression, and data segments compression.
Also discussed is the so-called “random access compressed file.” Having random write compressed files in the Postgres core would allow many very cool things. Andrey believes this component could increase OLTP performance by a significant multiplier on IO bottlenecked installations.
Andrey Borodin has been hacking on Postgres since 2016. He is an associated professor at Yandex School for Data Analysis and Ural Federal University.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon