On Thu, Sep 10, 2020 at 7:16 PM tsunakawa.ta...@fujitsu.com <tsunakawa.ta...@fujitsu.com> wrote:
> ALTER TABLE takes long time proportional to the amount of existing data, > while wal_level = none doesn't. Right, but if wal_level=none is considered OK for that table with existing data, then why not just create the table UNLOGGED in the first place? (or ALTER it to set UNLOGGED just one time and then leave it as UNLOGGED). Kind Regards, Peter Smith. Fujitsu Australia
