| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: WORM and Read Only Tables (v0.1) |
| Date: | 2007-12-11 15:35:33 |
| Message-ID: | 1197387333.4255.1346.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mason Hale | 2007-12-11 15:37:28 | Re: partitioned table query question |
| Previous Message | Andrew Chernow | 2007-12-11 15:31:46 | Re: PGparam proposal |