Postgres Pro
Downloads
Home   >   mailing lists

alter table xxx set unlogged take long time - Mailing list pgsql-performance

From James Pang (chaolpan)
Subject alter table xxx set unlogged take long time
Date
Msg-id PH0PR11MB5191F1E9F55101897E453814D6949@PH0PR11MB5191.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: alter table xxx set unlogged take long time  (Jim Mlodgenski <jimmy76@gmail.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: data consolidation: logical replication design considerations
Next
From: Jim Mlodgenski
Date:
Subject: Re: alter table xxx set unlogged take long time