Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim Mlodgenski
Subject Re: alter table xxx set unlogged take long time
Date
Msg-id CAB_5SRdsCDx8Mq974S=WxWBG+vSD7axZVtAoTvMvzQ+6ghffuA@mail.gmail.com
Whole thread Raw
In response to alter table xxx set unlogged take long time  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Responses RE: alter table xxx set unlogged take long time  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List pgsql-performance
Tree view


On Tue, Jul 26, 2022 at 4:53 AM James Pang (chaolpan) <chaolpan@cisco.com> wrote:

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?

 

Yes, the whole table needs to be written to WAL so this could take a long time for a large table

pgsql-performance by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: alter table xxx set unlogged take long time
Next
From: "James Pang (chaolpan)"
Date:
Subject: RE: alter table xxx set unlogged take long time