From: Kyotaro Horiguchi <horikyota....@gmail.com> > If we can skip the table-copy when ALTER TABLE SET LOGGED on > wal_level=minimal, is your objective achived?
I expect so, if we can skip the table copy during ALTER TABLE SET LOGGED/UNLOGGED. On the other hand, both approaches have different pros and cons. It's nice that ALTER TABLE doesn't require database restart, but the user has to specify tables. wal_level = none is vice versa. Anyway, wal_level = none would be useful for initial data loading after creating a new database cluster, as MySQL suggests. Regards Takayuki Tsunakawa
