Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey
Date
Msg-id CABOikdNuK1+FYxNx=KRQ48p+tH_J4SPa44VypaL_-+SqZm3TxA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers


On Mon, Jan 2, 2017 at 8:52 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:

I think there is some chance that such a change could induce
regression for the cases when there are many index columns or I think
even when index is on multiple columns (consider index is on first and
eight column in a ten column table).  


I don't see that as a problem because the routine only checks for columns that are passed as "interesting_cols".

Noticed below comment in interesting-attrs-2.patch
+ * are considered the "key" of rows in the table, and columns that are
+ * part of indirect indexes.

Is it right to mention about indirect indexes in above comment
considering indirect indexes are still not part of core code? 

I agree. We can add details about indirect indexes or WARM later, as and when those patches get committed.
 
Pavan, please rebase your WARM patch on top of this and let me know how
you like it.  I'll post a new version of indirect indexes later this
week.


I've rebased WARM on top of this patch and the proposed changes look fine from WARM's perspective too. I'll send rebased patches separately. 

Thanks,
Pavan

--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey
Next
From: Steve Singer
Date:
Subject: Re: [HACKERS] Logical Replication WIP