PostgreSQL columnstore indexing best practices

Agenda:

• Columnstore indexing basics – how to define them and how they work
• Comparison of columnar storage strategies for PostgreSQL
• Which table and column types benefit most from columnstore indexes?
• Compression – optimizing for storage vs. performance
• Indexing primary databases versus read replicas?
• Index latency vs. table coverage