Intro to PostgreSQL Columnstore indexing

Agenda:

  • How Columnstore indexes work
  • Columnstore index syntax in PostgreSQL
  • What Columnstore indexes do and don’t do
  • Columnstore index best practices
  • Columnstore performance demo & benchmarks

ColumnStore Indexing in PostgreSQL