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.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
