> 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