Re: CLUSTER and indisclustered

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CLUSTER and indisclustered
Дата
Msg-id 15622.1028730373@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CLUSTER and indisclustered  (Hannu Krosing <hannu@tm.ee>)
Ответы Re: CLUSTER and indisclustered
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> On Wed, 2002-08-07 at 15:26, Tom Lane wrote:
>> Right.  One form of the "lossy compression" idea I suggested is to
>> switch from a per-tuple bitmap to a per-page bitmap once the bitmap gets
>> too large to work with.  

> If it is a real bitmap, should it not be easyeast to allocate at the
> start ?

But it isn't a "real bitmap".  That would be a really poor
implementation, both for space and speed --- do you really want to scan
over a couple of megs of zeroes to find the few one-bits you care about,
in the typical case?  "Bitmap" is a convenient term because it describes
the abstract behavior we want, but the actual data structure will
probably be nontrivial.  If I recall Ann's description correctly,
Firebird's implementation uses run length coding of some kind (anyone
care to dig in their source and get all the details?).  If we tried
anything in the way of lossy compression then there'd be even more stuff
lurking under the hood.
        regards, tom lane


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: CLUSTER and indisclustered
Следующее
От: Hannu Krosing
Дата:
Сообщение: Off-topic: FUNC_MAX_ARGS benchmarks