Re: WORM and Read Only Tables (v0.1)

On Tue, 2007-12-11 at 13:44 +0100, Csaba Nagy wrote:
> On Tue, 2007-12-11 at 11:12 +0000, Simon Riggs wrote:
> > Features
> > - Read Only Tables
> > - Compressed Tablespaces
> 
> I wonder if instead of read-only tables wouldn't it be better to have
> some kind of automatic partitioning 

That's definitely on my list of requirements for partitioning.

> which permits to have different
> chunks of the table data in different tablespaces, and a freeze command
> which effectively moves the data from the (normally small) active chunk
> to the archive chunk when it's transaction id is older than a predefined
> threshold ?

As Hannu says, this is exactly what the other features will allow, so
Yes!

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com