Open Source Summit + ELC North America 2020

Zedstore is an open-source compressed columnar storage layer for Postgres being developed from the ground up with the goal to be incorporated into core Postgres. Apart from supporting and optimizing for OLAP workloads, it aims to support the entire feature set that Postgres' row store (heap tables) offers: MVCC compliance, crash safety, replication, updates, deletes, singleton inserts, all flavors of indexes, vacuum and storage-aware-query-plans, in order to be truly HTAP compliant. Zedstore offers a fresh take on column store design opting for B-Trees as the primary on-disk structure. Its flexible design allows for features such as column families or even its use as a compressed row store.

This talk will introduce the kinds of workloads column stores are specialized for and detail how Zedstore performs on those workloads and dive into its unique architecture. The audience can expect insights into how Zedstore is benchmarked, how one may monitor Zedstore deployments and open areas of development.