PostgreSQL Parallelism Do’s and Don’ts

PostgreSQL can apply parallel processing to speed up query performance. But the PostgreSQL query planner and internals are complex, making it a challenge to predict how parallel processing will affect different queries.

In this webinar, you’ll learn parallelism best practices to maximize your PostgreSQL query performance.

Swarm64 Solution Architect, Sebastian Dressler, will explain:

– A brief history of parallelism in PostgreSQL
– What parallel processing does and does not accelerate in PostgreSQL
– How to increase parallelism to speed up queries
– Common mistakes that block parallelism in PostgreSQL
– PostgreSQL parallelism best practices
– Database configuration
– Hardware choices
– Determining which queries will benefit most from parallelism