PostgreSQL 19's pg_plan_advice turned a 28ms query into 264ms under load
8.1 relevance
Score Breakdown
technical depth 9
novelty 8
actionability 8
community 7
strategic 6
personal 9
Scored daily by a customisable AI persona to surface the most relevant engineering leadership news.
Real-world PostgreSQL 19 planner extension testing with performance data, highly actionable for database engineers.
Summary
PostgreSQL 19's new pg_plan_advice contrib module lets developers inject planner hints via SET commands, but testing shows it can degrade performance dramatically when misapplied. A 28ms indexed query ballooned to 264ms under 10-client concurrency after forcing a sequential scan, revealing a 9.3x penalty versus 2.6x single-client. The module provides honest feedback when hints can't be honored, but the author found no case where hints improved on the planner's default choices.