Skip site navigation (1) Skip section navigation (2)

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

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Hannu Krosing <hannu(at)skype(dot)net>
Subject: Re: A more general approach (Re: Data archiving/warehousing idea)
Date: 2007-02-01 19:03:11
Message-ID: 45C2396F.7090405@cheapcomplexdevices.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hannu Krosing wrote:
> ...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.

Seems you could do "one bit per page" compression even with
visibility data stored in the pages themselves.

I could imagine a table re-writing "vacuum freeze" that finds
pages with all data visible to everyone and packs them with
a single bit saying "everything here's frozen".

The penalty would be an expensive splitting of the page (and
who knows what evil locks would be needed) if an update is
ever done on those wholly frozen pages -- but we're talking
about read-mostly tables here so that tradeoff might not be bad.

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-02-01 19:14:07
Subject: Re: pg_restore fails with a custom backup file
Previous:From: Tom LaneDate: 2007-02-01 18:02:37
Subject: Re: max_locks_per_transactions ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group