Re: Partial hash index is not used for implied qual.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergei Glukhov <s(dot)glukhov(at)postgrespro(dot)ru>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Partial hash index is not used for implied qual.
Date: 2025-11-27 17:00:37
Message-ID: 132953.1764262837@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sergei Glukhov <s(dot)glukhov(at)postgrespro(dot)ru> writes:
> On 11/27/25 7:01 AM, David Rowley wrote:
>> On Thu, 27 Nov 2025 at 07:26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> 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.

>> 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.

OK, I'll backpatch then.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2025-11-27 17:28:35 Re: Second RewriteQuery complains about first RewriteQuery in edge case
Previous Message Antonin Houska 2025-11-27 16:56:25 Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements