From: Peter Smith <smithpb2250@gmail.com>
> Earlier, Osumi-san was rejecting the idea of using ALTER TABLE tbl SET
> UNLOGGED on basis that it is too time consuming for large data to
> switch the table modes [1].
> Doesn't wal_level=none essentially just behave as if every table was
> UNLOGGED; not just the ones we are loading?
>
> Doesn't wal_level=none come with all the same limitations/requirements
> (full daily backups/restarts etc) that the UNLOGGED TABLE would also
> have?
ALTER TABLE takes long time proportional to the amount of existing data, while wal_level = none doesn't.
Regards
Takayuki Tsunakawa