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