Message-ID: <32bb39c7-7c52-412d-9ea8-fa1376b758db@gmail.com>
Date: Fri, 19 Sep 2025 09:50:41 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Why isn't PG using an index-only scan?
To: David Rowley <dgrowleyml@gmail.com>
Cc: Jean-Christophe BOGGIO <postgresql@thefreecat.org>,
 "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
References: <8f25c08c-acb2-47ca-b8c1-6664fc31a361@thefreecat.org>
 <CAApHDvoUdvw68oHnfACQE=u8XPJ+Te49dZsfC2yW+DVfzdT2+Q@mail.gmail.com>
 <32dc1fe9-175a-4894-b4c4-c6cdc6a76a16@gmail.com>
 <CAApHDvodjGfmN8_na70Bn5OVPO1-gQo64s6n=HUxqnUUQFsUZA@mail.gmail.com>
 <ed9e8643-a7ed-48b7-abea-6eb74e71e043@gmail.com>
 <CAApHDvogm2ULHZUnmrzX+V3QQmB7cVE6+8-B91P+LcemTQSC9Q@mail.gmail.com>
Content-Language: en-US
From: Andrei Lepikhov <lepihov@gmail.com>
In-Reply-To: 
 <CAApHDvogm2ULHZUnmrzX+V3QQmB7cVE6+8-B91P+LcemTQSC9Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/32bb39c7-7c52-412d-9ea8-fa1376b758db%40gmail.com>
Precedence: bulk

On 19/9/2025 03:05, David Rowley wrote:
> On Thu, 18 Sept 2025 at 23:55, Andrei Lepikhov <lepihov@gmail.com> 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