Postgres Pro
Downloads
Home   >   mailing lists

Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Date
Msg-id 20201013202031.GP9241@telsasoft.com
Whole thread Raw
In response to Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint  (Soumyadeep Chakraborty <soumyadeep2007@gmail.com>)
Responses Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Patch] Using Windows groups for SSPI authentication
Next
From: Tom Lane
Date:
Subject: Re: [Patch] Using Windows groups for SSPI authentication