Columnar Store for PostgreSQL Using cstore_fdw Webinar

Описание: This webinar gives an in-depth guide to cstore_fdw, an open source PostgreSQL extension which lets you store tables in columnar form. Columnar storage differs from row-based storage by storing the data in a column in contiguous blocks on disk in compressed form, as opposed to storing each row separately. Columnar storage can significantly reduce storage size, memory footprint, and I/O utilization for on-line analytical processing (OLAP) workloads. We take a closer look at the ORC storage format that cstore_fdw uses and discuss key features such as skip-list indexes. We then demonstrate how to set up a database that has both columnar and row-based tables which can even be joined together, a feature we believe is unique to PostgreSQL. During the demo, we also show a significant reduction in storage size when using cstore_fdw tables to store JSONB (known for its high storage overhead). Finally, we give a number of recommendations for tuning cstore_fdw and the type of workloads for which it is best suited. To download the webinar slides, visit www.citusdata.com/resources/webinars/columnar-store-postgresql-using-cstorefdw.