From: Sergei Glukhov <s.glukhov@postgrespro.ru>
To: David Rowley <dgrowleyml@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Partial hash index is not used for implied qual.
Date: Thu, 27 Nov 2025 12:39:34 +0400
Message-ID: <7009dd30-5d4e-49a2-af1d-c1b5f8e02288@postgrespro.ru> (raw)
In-Reply-To: <CAApHDvrsnR+=CU4wE1haWWO+ZjjN1m22joLqifrJgXv1mf+6yQ@mail.gmail.com>
References: <e200bf38-6b45-446a-83fd-48617211feff@postgrespro.ru>
<CAApHDvpVazvK7jAjpMWW5FYR4RQZ2NT8HidS03un8T+Ha8ZQDw@mail.gmail.com>
<1106189.1764033798@sss.pgh.pa.us>
<1112416.1764036072@sss.pgh.pa.us>
<CAApHDvpVwXQgiatD_FM_F3fYKU-j1kqPeTQn-xeRptc2nyGRVw@mail.gmail.com>
<1615744.1764181557@sss.pgh.pa.us>
<CAApHDvrsnR+=CU4wE1haWWO+ZjjN1m22joLqifrJgXv1mf+6yQ@mail.gmail.com>
Hi,
On 11/27/25 7:01 AM, David Rowley wrote:
> On Thu, 27 Nov 2025 at 07:26, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So I'm inclined to apply the attached and just call it good.
> I think the patch looks fine.
+1, verified, thanks a lot!
>
>> Should we back-patch? I'm unsure. Clearly it's a bug that we
>> cannot generate an indexscan plan in this case, but we've learned
>> that changing plans in released branches is often not wanted.
>> And given the lack of field complaints, nobody is using the case
>> anyway.
> I feel like anyone adding a partial hash index has done so quite
> purposefully. I suspect they might be surprised if there's no means
> whatsoever to use that index in scans, so perhaps it's ok to
> backpatch.
>
> Sergei, can you confirm if this was something he noticed when playing
> around on master, or if this came from a field report?
It was reported for v16.
Regards,
Sergei Glukhov
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: pgsql-hackers@postgresql.org
Cc: s.glukhov@postgrespro.ru, dgrowleyml@gmail.com, tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org
Subject: Re: Partial hash index is not used for implied qual.
In-Reply-To: <7009dd30-5d4e-49a2-af1d-c1b5f8e02288@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox