alter table xxx set unlogged take long time

James Pang (chaolpan) <chaolpan@cisco.com>

From: "James Pang (chaolpan)" <chaolpan@cisco.com>
To: "pgsql-performance@lists.postgresql.org" <pgsql-performance@lists.postgresql.org>
Date: 2022-07-26T08:53:29Z
Lists: pgsql-performance
Hi ,
We have PG v13.6 in RHEL8.4, we try to set table unlogged before load data.  There are a lot of existing data in this table, when 'alter table xxx  set unlogged', we found it take long time and spend time on IO datafileread.  Is it expected?

Thanks,

James