> 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:
yes, but it would mean re-writing the whole data + re-creating the indexes. I didn't know that some statements don't write WAL at all if wal_level is minimal (they just fsync at the end). Couldn't that be done in the UNLOGGED to "regular" case? That is: if wal_level is minimal, you can transform an unlogged table into a logged one, without having to rewrite data + indexes: "just" fsync it and be done with it. Wouldn't that be useful? Leonardo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
