Re: Multiple COPY on the same table

2018-08-21 Thread Christopher Browne
On Mon, 20 Aug 2018 at 16:23, Adrian Klaver wrote: > > On 08/20/2018 08:56 AM, Nicolas Paris wrote: > >> Can I split a large file into multiple files and then run copy using > >> each file. > > > > AFAIK, copy command locks the table[1] while there is no mention of this > > in the documentation[2]

Re: Multiple COPY on the same table

2018-08-20 Thread Adrian Klaver
On 08/20/2018 08:56 AM, Nicolas Paris wrote: Can I split a large file into multiple files and then run copy using each file. AFAIK, copy command locks the table[1] while there is no mention of this in the documentation[2]. [1] Is from Postgres 7.1(17 years ago). I suspect the conditions have

Re: Multiple COPY on the same table

2018-08-20 Thread Nicolas Paris
> Can I split a large file into multiple files and then run copy using > each file. AFAIK, copy command locks the table[1] while there is no mention of this in the documentation[2]. > Will the performance boost by close to 4x?? You might be interested in the pbBulkInsert tool[3] that allows