Re: bitmap AM design

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bitmap AM design
Дата
Msg-id 19530.1109703941@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: bitmap AM design  ("Victor Y. Yegorov" <viy@mits.lv>)
Ответы Re: bitmap AM design
Список pgsql-hackers
"Victor Y. Yegorov" <viy@mits.lv> writes:
> All lists (list of ctids, bitmaps) will only grow, no data will be
> deleted, as deletes will require relocation and possibly exclusive
> lock on the index.
> Extending lists will need only a short-term exclusive locks on the pages in
> the tails of each list.

Hmm, you seem to be envisioning that these are actually lists, not
arrays --- that is, to find the N'th page in a list requires traversing
list links starting at the first page.  That doesn't sound workable.
If you can't access all the entries in roughly constant time then the
thing is going to have problems with big tables.

> I have counter question for you: you've mentioned, that you want bitmaps in
> the 8.1. What kind of bitmaps you were speaking about?

In-memory is what I intend to work on.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: bitmap AM design
Следующее
От: pgsql@mohawksoft.com
Дата:
Сообщение: Re: bitmap AM design