Re: alter table xxx set unlogged take long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: Jim Mlodgenski <jimmy76(at)gmail(dot)com>, "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:42:52
Message-ID: 2240967.1658839372@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"James Pang (chaolpan)" <chaolpan(at)cisco(dot)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 command into Postgres db 5. Alter table set xxx logged 6. Create index …

The easy answer is to skip steps 3 and 5.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

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