Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>
Cc: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Date: 2020-10-13 20:20:31
Message-ID: 20201013202031.GP9241@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 30, 2020 at 04:52:02PM -0700, Soumyadeep Chakraborty wrote:
> Hi Justin,
>
> Attached is a minimal patch that is rebased and removes the
> dependency on Konstantin's earlier patch[1], making it enough to remove
> the extraneous index scans as Justin brought up. Is this the direction we
> want to head in?

Yes, thanks for doing that. I hadn't dug into it yet to figure out what to put
where to separate the patches. It seems like my patch handles a different goal
than Konstantin's, but they both depend on having the constraints populated.

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-10-13 20:32:21 Re: [Patch] Using Windows groups for SSPI authentication
Previous Message Tom Lane 2020-10-13 19:32:14 Re: [Patch] Using Windows groups for SSPI authentication