Performance

Understanding PostgreSQL Parallel Query Execution: Multi-Core Performance
Feb 16, 2026 Architecture

Understanding PostgreSQL Parallel Query Execution: Multi-Core Performance

Deep dive into PostgreSQL's parallel query execution—how Gather nodes, parallel workers, and multi-core processing accelerate large table scans, hash joins, and aggregations. Learn when parallelism helps, when it hurts, and how to tune it.

PostgreSQLPerformanceParallel Query
Understanding PostgreSQL's Volcano Model: The Iterator Execution Architecture
Feb 15, 2026 Architecture

Understanding PostgreSQL's Volcano Model: The Iterator Execution Architecture

Deep dive into the Volcano Model—PostgreSQL's foundational execution architecture. Learn how Next()/GetNext() drives every query, why row-by-row processing matters, and when vectorization breaks the rules.

PostgreSQLDatabase InternalsPerformance