Re: Best way to scan on-disk bitmaps

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Best way to scan on-disk bitmaps
Дата
Msg-id 12035.1115928615@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Best way to scan on-disk bitmaps  ("Victor Y. Yegorov" <viy@mits.lv>)
Ответы Re: Best way to scan on-disk bitmaps  ("Victor Y. Yegorov" <viy@mits.lv>)
Список pgsql-hackers
"Victor Y. Yegorov" <viy@mits.lv> writes:
> I have questions on how to implement on-disk bitmap scan.

I think your best plan might be

1. Be sure that all the indexable WHERE conditions are passed to the  indexscan as indexquals.  This might be,
say,WHEREa = 42 and b = 'foo'
 

2. Within the index AM, form the AND of the relevant bitmaps (here the  ones for a = 42 and b = 'foo').

3. Within the index AM, pick up the TIDs for the remaining one-bits,  and pass them back.

4. Let the existing machinery handle the OR-ing problem as well as  actual fetching of the heap rows.

This can be done without any restructuring of the index AM API.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Views, views, views: Summary of Arguments
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Server instrumentation for 8.1