Date: 2020-05-27
Time: 14:00–14:45
Room: Stream 2
Level: Intermediate
Zedstore is a column store for PostgreSQL that targets to reduce I/Os for queries that only need access to a few columns out of a wide table, to improve performance for analytics workloads, and to enable better compressions. It is under development and it uses the table AM APIs that were introduced in PostgreSQL V12.
This talk will cover the use cases for column store in Postgres, the architecture and design decisions of Zedstore, performance and size comparisons between Zedstore and Heap tables for both OLTP and OLAP queries, changes required in the table AM APIs to accommodate table AMs other than heap, and the latest development status of Zedstore.
The following slides have been made available for this session: