Introduction to PostgreSQL ColumnStore Indexes
Channel: Postgres Conference
Date: 2021-07-30

Swarm64 DA 5.0 introduces ColumnStore indexes for PostgreSQL, which can be defined for any table and greatly reduce I/O to speed up query performance. They are ideal for data warehousing and analytics workloads.

Swarm64 Solution Architect, Sebastian Dressler, will cover the following:

- How ColumnStore indexes work
- ColumnStore index syntax in PostgreSQL
- What ColumnStore indexes do and don’t do
- ColumnStore index best practices
- Table coverage
- Index updates
- Compression levels
- Columnstore index replication, crash-safety
- Columnstore performance demo & benchmarks