Skip to content

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.

DevTools dev.to
PostgreSQL 19's pg_plan_advice turned a 28ms query into 264ms under load
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.

Author

Alex Georgiev

More from Alex Georgiev →