public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: David Rowley <[email protected]>
Cc: Jean-Christophe BOGGIO <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Why isn't PG using an index-only scan?
Date: Fri, 19 Sep 2025 09:50:41 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAApHDvogm2ULHZUnmrzX+V3QQmB7cVE6+8-B91P+LcemTQSC9Q@mail.gmail.com>
References: <[email protected]>
<CAApHDvoUdvw68oHnfACQE=u8XPJ+Te49dZsfC2yW+DVfzdT2+Q@mail.gmail.com>
<[email protected]>
<CAApHDvodjGfmN8_na70Bn5OVPO1-gQo64s6n=HUxqnUUQFsUZA@mail.gmail.com>
<[email protected]>
<CAApHDvogm2ULHZUnmrzX+V3QQmB7cVE6+8-B91P+LcemTQSC9Q@mail.gmail.com>
On 19/9/2025 03:05, David Rowley wrote:
> On Thu, 18 Sept 2025 at 23:55, Andrei Lepikhov <[email protected]> wrote:
>> Perhaps we should start working on introducing this type of callback/ hook?
> There's certainly places where you could add a hook that would just
> add an unacceptable overhead that we couldn't stomach. I expect
> ExecProcNode would be one of those places.
That seems a bit odd. It is not a significant issue to instruct the
compiler to trust the 'else' branch of the "if (PlanState::hook !=
NULL)" condition and reduce overhead to zero. However, if the hook is
set, it indicates that the user (module or extension) genuinely needs it
to be called for this specific node.
> I do agree that trying to come up with something for this is worthy of
> some time and effort. Helping people with performance issues when they
> can't even get EXPLAIN ANALYZE to finish is quite tricky.That's all I need; thank you. Starting a PostgreSQL project without
positive feedback from a committer usually results in wasted time,
unless you are purely conducting research ;).
-- regards, Andrei Lepikhov
view thread (9+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Why isn't PG using an index-only scan?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox