Re: No heap lookups on index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: No heap lookups on index
Дата
Msg-id 2709.1137617443@sss.pgh.pa.us
обсуждение исходный текст
Ответ на No heap lookups on index  (David Scott <davids@apptechsys.com>)
Ответы Re: No heap lookups on index  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: No heap lookups on index  (David Scott <davids@apptechsys.com>)
Список 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 по дате отправления:

Предыдущее
От: David Scott
Дата:
Сообщение: No heap lookups on index
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Bad estimate on LIKE matching