postgresql
- Why Your 16-Core Database Isn't Multithreading Queries
Your beefy database server has 16 cores, but queries feel slow. Discover why PostgreSQL might not be using parallel execution, and how to fix it.
postgresqlparallel-querydatabaseperformancebackend - PostgreSQL's Query Planner: Decoding Optimal Execution
Demystify the PostgreSQL query planner's core decisions. Understand how the cost-based optimizer picks query plans and master EXPLAIN ANALYZE for peak…
postgresqlquery-optimizerexplain-analyzedatabase-performanceinternals - PostgreSQL Query Planner Internals: How the Cost-Based Optimizer Chooses a Plan
An overview of PostgreSQL's planner: cost model, statistics, join ordering, and why the wrong plan gets chosen sometimes.
postgresqlbackendperformance - Why your database connection pool is probably misconfigured
Connection pools look simple until your app falls over at 3am. Here's the math behind sizing them correctly, and the mistakes that get everyone eventually.
postgresqlbackendperformance - From ILIKE '%query%' to search that feels instant
LIKE queries work fine until your table grows. The real path from a slow sequential scan to search that returns results as you type.
postgresqlsearchbackendperformance