Compressed columnstore indexes greatly accelerate queries on your PostgreSQL tables

Thursday, December 10, 10AM Pacific

Swarm64 Solution Architect, Sebastian Dressler will explain columnstore indexing best practices to help you get the best query performance out of your Postgres database.

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