Re: TODO items

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: TODO items
Дата
Msg-id
28341.1060363577@sss.pgh.pa.us
Ответ на
Re: TODO items (Bruce Momjian)
Список
Дерево обсуждения
TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Josh Berkus <josh@agliodbs.com>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Joe Conway <mail@joeconway.com>
Re: TODO items Josh Berkus <josh@agliodbs.com>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Joe Conway <mail@joeconway.com>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Josh Berkus <josh@agliodbs.com>
Re: TODO items Joe Conway <mail@joeconway.com>
Re: PROCEDURES was: TODO items Josh Berkus <josh@agliodbs.com>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Tom Lane <tgl@sss.pgh.pa.us>
Re: TODO items Hannu Krosing <hannu@tm.ee>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Tom Lane <tgl@sss.pgh.pa.us>
Re: TODO items Joe Conway <mail@joeconway.com>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO items Tom Lane <tgl@sss.pgh.pa.us>
Re: TODO items Bruce Momjian <pgman@candle.pha.pa.us>
Bruce Momjian  writes:
>>> * Use index to restrict rows returned by multi-key index when used with
>>> non-consecutive keys or OR clauses, so fewer heap accesses
>> 
>> Not sure what this means.

> This is a Vadim idea.  The idea was that if you had a multi-key index on
> col1,col2,col3, and you wanted to do a lookup on col1,col3, you could
> still use the index, and just run through all the matching col1 values
> looking for a matching col3 in the index, rather than going to the heap
> and looking for a col3 match?  Is this item worth keeping?

Hmm.  Maybe.  Might as well leave it there awhile longer.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
От: Josh Berkus
Дата:
Сообщение: Re: TODO items
FAQ