20x faster queries & easier SQL Server migration

Swarm64 Solution Architect, Sebastian Dressler explains how to use new Columnstore indexes–an easy way to speed up PostgreSQL query performance by 20x.

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