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.
Slides
The following slides have been made available for this session: