PGConf.us 2017 "In-core Compression" Talk Slides
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.