Introduction to PostgreSQL ColumnStore Indexes

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