Re: WORM and Read Only Tables (v0.1) - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: WORM and Read Only Tables (v0.1)
Date
Msg-id 1197377419.14272.70.camel@PCD12478
Whole thread Raw
In response to Re: WORM and Read Only Tables (v0.1)  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-hackers
On Tue, 2007-12-11 at 13:44 +0100, Csaba Nagy wrote:
> Another advantage I guess would be that active data would more likely
> stay in cache, as updated records would stay together and not spread
> over the inactive.

And I forgot to mention that vacuum could mostly skip the archive part,
and only vacuum the active part, which would drastically reduce the cost
of vacuuming big & active tables.

Cheers,
Csaba.




pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: WORM and Read Only Tables (v0.1)
Next
From: Hannu Krosing
Date:
Subject: Re: WORM and Read Only Tables (v0.1)