Re: alter table xxx set unlogged take long time

From: Jim Mlodgenski <jimmy76(at)gmail(dot)com>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: alter table xxx set unlogged take long time
Date: 2022-07-26 12:21:26
Message-ID: CAB_5SRdsCDx8Mq974S=WxWBG+vSD7axZVtAoTvMvzQ+6ghffuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jul 26, 2022 at 4:53 AM James Pang (chaolpan) <chaolpan(at)cisco(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-07-26 12:41:07 RE: alter table xxx set unlogged take long time
Previous Message James Pang (chaolpan) 2022-07-26 08:53:29 alter table xxx set unlogged take long time