Postgres Pro
Downloads
Home   >   mailing lists

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

From James Pang (chaolpan)
Subject RE: alter table xxx set unlogged take long time
Date
Msg-id PH0PR11MB51917F811DDACDBC4B0D9AEAD6949@PH0PR11MB5191.namprd11.prod.outlook.com
Whole thread Raw
In response to Re: alter table xxx set unlogged take long time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: alter table xxx set unlogged take long time  (Jim Mlodgenski <jimmy76@gmail.com>)
Re: alter table xxx set unlogged take long time  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-performance
Tree view 
Without step 3 ,  copy data take long time.   Use wal_level=minimal can help make COPY load data without logging ?

Thanks,

James

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us> 
Sent: Tuesday, July 26, 2022 8:43 PM
To: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: Jim Mlodgenski <jimmy76@gmail.com>; pgsql-performance@lists.postgresql.org
Subject: Re: alter table xxx set unlogged take long time

"James Pang (chaolpan)" <chaolpan@cisco.com> writes:
> How to make it fast ?  These are our steps about copy large data from Oracle to Postgres
>   1.  Create table in Postgres  2. Extract data from Oracle to CSV  3. Alter table set xxx unlogged,   4. Run copy
commandinto Postgres db  5. Alter table set xxx logged  6. Create index …
 

The easy answer is to skip steps 3 and 5.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter table xxx set unlogged take long time
Next
From: Jim Mlodgenski
Date:
Subject: Re: alter table xxx set unlogged take long time