Re: alter table xxx set unlogged take long time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: alter table xxx set unlogged take long time
From: Jim Mlodgenski <jimmy76@xxxxxxxxx>
Date: Tue, 26 Jul 2022 08:21:26 -0400
Cc: "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <PH0PR11MB5191F1E9F55101897E453814D6949@PH0PR11MB5191.namprd11.prod.outlook.com>
References: <PH0PR11MB5191F1E9F55101897E453814D6949@PH0PR11MB5191.namprd11.prod.outlook.com>

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

Follow-Ups:
- RE: alter table xxx set unlogged take long time
  - From: James Pang (chaolpan)

References:
- alter table xxx set unlogged take long time
  - From: James Pang (chaolpan)

Prev by Date: alter table xxx set unlogged take long time
Next by Date: RE: alter table xxx set unlogged take long time
Previous by thread: alter table xxx set unlogged take long time
Next by thread: RE: alter table xxx set unlogged take long time
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux