From: Peter Smith <smithpb2...@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