In-core compression: how to shrink your database size in several times by Anastasia Lubennikova

Wednesday, November 16 at 1:20-2:15

Right now postgres can't compress it's data in many situations and that leads sometimes to increased storage overhead by the order of magnitude comparing with commercial DBMS. Common viewpoint that this task can be accomplished by file system level compression but most popular and well tested Linux file system can't do that. I will talk about our patches that implements page compression on disk or on disk + in memory; in what situation it is better to use what kind of compression; and also discuss experience of using compression in production.

About the Speaker

Anastasia is a graduate of the NRNU MEPhI with a B.S. in Applied Math and Informatics in 2015. She participated GSoC with PostgreSQL in 2014. Her primary interests are indexes and optimal data structures. Anastasia is a developer at Postgres Professional. Anastasia also coordinates "Hacking PostgreSQL" course, where has lectures about different subsystems, details of their implementation and tips for new developers.

Monday, September 12, 2016 - 21:30