pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sergei Glukhov <s.glukhov@postgrespro.ru>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Partial hash index is not used for implied qual.
Date: Thu, 27 Nov 2025 12:00:37 -0500
Message-ID: <132953.1764262837@sss.pgh.pa.us> (raw)
In-Reply-To: <7009dd30-5d4e-49a2-af1d-c1b5f8e02288@postgrespro.ru>
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>
	<7009dd30-5d4e-49a2-af1d-c1b5f8e02288@postgrespro.ru>

Sergei Glukhov <s.glukhov@postgrespro.ru> writes:
> 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:
>>> 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





view thread (11+ messages)

Message-ID: <132953.1764262837@sss.pgh.pa.us>
Permalink:  ../132953.1764262837@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/132953.1764262837@sss.pgh.pa.us

 · 

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: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, s.glukhov@postgrespro.ru, dgrowleyml@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Partial hash index is not used for implied qual.
  In-Reply-To: <132953.1764262837@sss.pgh.pa.us>

* 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