alter table xxx set unlogged take long time

From: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: alter table xxx set unlogged take long time
Date: 2022-07-26 08:53:29
Message-ID: PH0PR11MB5191F1E9F55101897E453814D6949@PH0PR11MB5191.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Mlodgenski 2022-07-26 12:21:26 Re: alter table xxx set unlogged take long time
Previous Message Rory Campbell-Lange 2022-07-23 08:40:23 Re: data consolidation: logical replication design considerations