Re: No heap lookups on index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: No heap lookups on index
Date
Msg-id 2709.1137617443@sss.pgh.pa.us
Whole thread Raw
In response to No heap lookups on index  (David Scott <davids@apptechsys.com>)
Responses Re: No heap lookups on index  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: No heap lookups on index  (David Scott <davids@apptechsys.com>)
List pgsql-hackers
David Scott <davids@apptechsys.com> writes:
>     Is the additional overhead of keeping full tuple visibility 
> information inside of the index so odious to the Postgres community as 
> to prevent a patch with this solution from being applied back to the 
> head?

This has been discussed and rejected before (multiple times).  If you
want it considered you'll have to present stronger arguments than have
so far been made.  The current consensus is that the probability of a
net performance win is not good enough to justify the large amount of
development effort that would be required.

What sort of problems are you dealing with exactly?  There has been
some discussion of changes that would improve certain scenarios.  For
instance it might be plausible to do joins using index information and
only go back to the heap for entries that appear to pass the join test.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Scott
Date:
Subject: No heap lookups on index
Next
From: Simon Riggs
Date:
Subject: Re: Bad estimate on LIKE matching