Latest News
Start your free PG Nitrous Trial Get started ›
Swarm64 & EDB partner to extend Postgres with faster queries Read more ›
Blog Post: Introducing the Swarm64 DA PostgreSQL Settings Advisor 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