guessing that the paucity of feedback
thus far is partly because there's a lot of stuff to absorb -- though
the main point at this stage is really to get some opinions on the
planner infrastructure/hooks, which don't necessarily require full
understanding of (never mind agreement with) the des
;ve spent some time playing with these patches. I still don't have to
much comments on the syntax yet but I've noticed a small bug or perhaps
I'm missing something?
When I run CREATE EXTENSION pg_plan_advice I'm able to use the
EXPLAIN(plan_advice) but if try to open another conne
On Thu, Oct 30, 2025 at 9:00 PM Robert Haas wrote:
> First, any form of user control over the
> planner tends to be a lightning rod for criticism around here. I've
> come to believe that's the wrong way of thinking about it: we can want
> to improve the planner over the long term and *also* want t
On Sat, Nov 1, 2025 at 12:10 PM Hannu Krosing wrote:
> This reinforces my belief thet we either should have some kind of
> two-level optimization, where most queries are handled quickly but
> with something to trigger a more elaborate optimisation and
> investigation workflow.
>
> Or alternatively
On Fri, Oct 31, 2025 at 5:17 PM Alastair Turner wrote:
> I really like the functionality of the current patch as well, even though I
> am suspicious of user control over the planner. By giving concise, precise
> control over a plan, this allows people who believe they can out-plan the
> planner
This weas recently shared in LinkedIn
https://www.vldb.org/pvldb/vol18/p5126-bress.pdf
For example it says that 31% of all queries are metadata queries, 78%
have LIMIT, 20% of queries have 10+ joins, with 0.52% exceeding 100
joins. , 12% of expressions have depths between 11-100 levels, some
excee
On Fri, 31 Oct 2025, 12:51 Robert Haas, wrote:
> On Fri, Oct 31, 2025 at 5:59 AM Jakub Wartak
> wrote:
> > > First, any form of user control over the planner tends to be a
> lightning rod for criticism around here.
> >
> > I do not know where this is coming from, but everybody I've talked to
> >
On Fri, Oct 31, 2025 at 5:59 AM Jakub Wartak
wrote:
> > First, any form of user control over the planner tends to be a lightning
> > rod for criticism around here.
>
> I do not know where this is coming from, but everybody I've talked to
> was saying this is needed to handle real enterprise datab
ut probably it's stupid,
heavyweight, but that would be my dream ;)
-J.
From 06038e237420b7054912118076e8b981def4f545 Mon Sep 17 00:00:00 2001
From: Jakub Wartak
Date: Fri, 31 Oct 2025 09:35:59 +0100
Subject: [PATCH] fixup: supress some gcc warnings
---
contrib/pg_plan_advice/pgpa_ast
