# Waiting for PostgreSQL 19 - Add pg\_plan\_advice contrib module.

DevFeed: [Waiting for PostgreSQL 19 - Add pg\_plan\_advice contrib module.](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-pg-plan-advice-contrib-module-33682.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/03/22/waiting-for-postgresql-19-add-pg_plan_advice-contrib-module/>)

Author: depesz

Published: 2026-03-22T13:44:10Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [systems](<https://devfeed.tech/topics/systems.md>)

Tags: [advice](<https://devfeed.tech/tags/advice.md>), [hint](<https://devfeed.tech/tags/hint.md>), [module](<https://devfeed.tech/tags/module.md>), [pg-plan-advice](<https://devfeed.tech/tags/pg-plan-advice.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [plan](<https://devfeed.tech/tags/plan.md>), [planner](<https://devfeed.tech/tags/planner.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [statistics](<https://devfeed.tech/tags/statistics.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

## AI overview

This article examines PostgreSQL's proposed pg_plan_advice contrib module, explaining why query planners sometimes choose suboptimal plans, how plan hints could stabilize or override those choices, and how to load and test the extension.

## Source excerpt

On 12nd of March 2026, Robert Haas committed patch: Add pg_plan_advice contrib module. Provide a facility that (1) can be used to stabilize certain plan choices so that the planner cannot reverse course without authorization and (2) can be used by knowledgeable users to insist on plan choices contrary to what the planner believes ... Continue reading "Waiting for PostgreSQL 19 - Add pg_plan_advice contrib module."