Conference Schedule - PGConf.EU 2019

Data Compression in PostgreSQL and its future

Date: 2019-10-16
Time: 15:40 - 16:30
Room: Foscolo
Level: Intermediate

There are few data compression features available in PostgreSQL today, but the community is currently developing data compression features that can be used in a variety of situations, including improvements to TOAST, columnar compression, and communication data compression. In this talk, I will share some of the compression features under development in the community and talk about future of data compression in PostgreSQL.

Also, I will present the page-based table compression for OLTP environments that we are working on, which compresses the data using a compression method that leverages the page items and places it in the cache. The purpose of this implementation is to reduce storage costs in OLTP with minimal overhead. I will talk about the structure and other details of the function, including the result of the performance evaluation.

Speaker

Iwata Aya