Re: A more general approach (Re: Data archiving/warehousing idea)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A more general approach (Re: Data archiving/warehousing idea)
Дата
Msg-id 19685.1170351107@sss.pgh.pa.us
обсуждение исходный текст
Ответ на A more general approach (Re: Data archiving/warehousing idea)  (Hannu Krosing <hannu@skype.net>)
Ответы Re: A more general approach (Re: Data archiving/warehousing idea)
Список pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> A more radical variation of the "restricted-use archive table" approach
> is storing all tuple visibility info in a separate file.
> At first it seems to just add overhead, but for lots (most ? ) usecases
> the separately stored visibility should be highly compressible, so for
> example for bulk-loaded tables you could end up with one bit per page
> saying that all tuples on this page are visible.

The more you compress, the slower and more complicated it will be to
access the information.  I'd put my money on this being a net loss in
the majority of scenarios.
        regards, tom lane


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Why is ecpg segfaulting on buildfarm member "clownfish"?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: max_locks_per_transactions ...