News for hackers. Stuff that matters.
Re:Pg_plan_advice: Plan Stability and User Planner Control f... by dujuku on Monday March 09, 2026 @06:34PM (#47316654)
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 f... by rhaas on Friday March 13, 2026 @07:59AM (#47363252)
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.