Re: A more general approach (Re: Data archiving/warehousing idea) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A more general approach (Re: Data archiving/warehousing idea)
Date
Msg-id 19685.1170351107@sss.pgh.pa.us
Whole thread Raw
In response to A more general approach (Re: Data archiving/warehousing idea)  (Hannu Krosing <hannu@skype.net>)
Responses Re: A more general approach (Re: Data archiving/warehousing idea)  (Hannu Krosing <hannu@skype.net>)
List 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 by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Why is ecpg segfaulting on buildfarm member "clownfish"?
Next
From: Tom Lane
Date:
Subject: Re: max_locks_per_transactions ...