Pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?

#1

Post by mrkaye97 » Sun, Mar 08, 2026, 6:27 PM UTC

Pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?
rhaas.blogspot.com

Re: Pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?

#2

Post by dujuku » Mon, Mar 09, 2026, 10:34 PM UTC

Good to see some movement on plan hints in postgres, but I can't get behind the ergonomics of stashing plan advice via query ID. Comment-based hints can be declared in the application, which is typically when you will want to update the hints when modifying the query. It's just a much simpler workflow and one which has a lot of precedence in other DBMSs.

Re: Pg_plan_advice: Plan Stability and User Planner Control for PostgreSQL?

#3

Post by rhaas » Fri, Mar 13, 2026, 11:59 AM UTC

dujuku wrote: post #2

Good to see some movement on plan hints in postgres, but I can't get behind the ergonomics of stashing plan advice via query ID. Comment-based hints can be declared in the application, which is typically when you will want to update the hints when modifying the query. It's just a much simpler workflow and one which has a lot of precedence in other DBMSs.

The infrastructure is intentionally pluggable to facilitate different viewpoints on questions like this. I hope we see various add-on modules pop up that fetch advice strings from various possible sources.