From: Tom Lane <tgl@sss.pgh.pa.us>
To: "James Pang (chaolpan)" <chaolpan@cisco.com>
cc: Jim Mlodgenski <jimmy76@gmail.com>,
        "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
Subject: Re: alter table xxx set unlogged take long time
In-reply-to: 
 <PH0PR11MB51919A15ED33C356120145F7D6949@PH0PR11MB5191.namprd11.prod.outlook.com>
References: 
 <PH0PR11MB5191F1E9F55101897E453814D6949@PH0PR11MB5191.namprd11.prod.outlook.com>
 <CAB_5SRdsCDx8Mq974S=WxWBG+vSD7axZVtAoTvMvzQ+6ghffuA@mail.gmail.com>
 <PH0PR11MB51919A15ED33C356120145F7D6949@PH0PR11MB5191.namprd11.prod.outlook.com>
Comments: In-reply-to "James Pang (chaolpan)" <chaolpan@cisco.com>
	message dated "Tue, 26 Jul 2022 12:41:07 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2240966.1658839372.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 26 Jul 2022 08:42:52 -0400
Message-ID: <2240967.1658839372@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2240967.1658839372%40sss.pgh.pa.us>
Precedence: bulk

"James Pang (chaolpan)" <chaolpan@cisco.com> writes:
> How to make it fast ?  These are our steps about copy large data from Or=
acle to Postgres
>   1.  Create table in Postgres  2. Extract data from Oracle to CSV  3. A=
lter table set xxx unlogged,   4. Run copy command into Postgres db  5. Al=
ter table set xxx logged  6. Create index =E2=80=A6

The easy answer is to skip steps 3 and 5.

			regards, tom lane