Re: read-only UNLOGGED tables

On Thu, Mar 31, 2011 at 08:57:09AM +0100, Leonardo Francalanci wrote:
> Hi,
>
> we're inserting tons of rows in some partitioned tables, and to get
> more performance out of the system we would like to use UNLOGGED
> tables that, after some time, become "regular" tables (at that point, we
> wouldn't want to write to them anymore; we could only select or drop
> them). Would it be a feature that can be added in the future, assuming
> that the tables would then flagged somehow as "read only"?

I suppose that a similar effect could be achieved by something like

CREATE TABLE mytable_logged AS
SELECT * FROM mytable_unlogged;

which would not produce WAL:

http://developer.postgresql.org/pgdocs/postgres/populate.html#POPULATE-PITR

unless of course you are using PITR or replication, in which case you
surely want your table to be logged at some point anyway.

Cheers,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni(dot)ciolli(at)2ndquadrant(dot)it | www.2ndquadrant.it