Home > mailing lists

Re: [External] Multiple COPY on the same table - Mailing list pgsql-general

From	Ravi Krishna
Subject	Re: [External] Multiple COPY on the same table
Date	August 21, 2018 00:16:39
Msg-id	2004276149.10290709.1534788999308@mail.yahoo.com Whole thread Raw
List	pgsql-general

1. The tables has no indexes at the time of load.

2. The create table and copy are in the same transaction.

So I guess that's pretty much it. I understand the long time it takes as some of the tables have 400+ million rows.

Also the env is a container and since this is currently a POC system , not much time has been invested in fine tuning it.

thanks all.

From: Ron
Date: 20 August 2018, 23:49:31
Subject: Re: [External] Multiple COPY on the same table

From: bricklen
Date: 21 August 2018, 00:45:10
Subject: Re: upgrading from pg 9.3 to 10