Latest News
PG Nitrous as a Fast Query Replica for RDS Read more ›
Columnstore indexing best practices Read more ›

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

View webcast on demand