2017 "In-core Compression" Talk

On 2017 Anastasia Lubennikova and I presented a talk "In-core compression: how to shrink your database size in several times". The slides for this talk are now available on SlideShare:

Download: postgresql-in-core-compression-pgconf2017.pdf (1.1M)

Here is a short description of the talk:

Currently PostgreSQL doesn't compress data in many cases when it's possible and can significantly reduce not only disk and memory usage but also the number of IO operations. A common view on this problem is that it can be solved on file system level. Unfortunately in Linux, which is probably the most commonly used server OS these days, corresponding file systems are either not ready for usage in production environment yet or can't achieve same compression ratio that can be achieved on DBMS level. In this talk we will present our patches that implement page compression on disk and, optionally, in memory; a ZSON extension that implement transparent JSONB compression; in what situation it is better to use what kind of compression; and also discuss our experience of using compression in production environment.

Video recording will be available on YouTube channel soon. More slides for 2017 talks are available on PostgreSQL Wiki. Slides for previous years could be found there as well.

UPD: And here is the video: