Introduction to PostgreSQL ColumnStore Indexes

Schedule

Presented by:

Wleytjpl 400x400

Sebastian Dressler

Swarm64

Sebastian loves to play with different technologies and bring them together to build creative solutions. In his role as Solution Architect at Swarm64 he helps customers to performance-optimize their PostgreSQL and understand how to fit Swarm64 DA into their environments.

Join us on September 29 for a 45-minute introduction to ColumnStore indexes in PostgreSQL.

Swarm64 DA 5.0 introduces ColumnStore indexes for PostgreSQL, which can be defined for any table and greatly reduce I/O to speed up query performance. They are ideal for data warehousing and analytics workloads.

Swarm64 Solution Architect, Sebastian Dressler, will cover the following:

  • How ColumnStore indexes work
  • ColumnStore index syntax in PostgreSQL
  • What ColumnStore indexes do and don’t do
  • ColumnStore index best practices
  • Table coverage
  • Index updates
  • Compression levels
  • Columnstore index replication, crash-safety
  • Columnstore performance demo & benchmarks

Date:
2020 September 29 10:00 UTC
Duration:
1 h
Room:
Online
Conference:
Postgres Webinar Series
Language:
Track:
Dev
Difficulty:
Requires Registration:
Yes (Registered: 179)