R: [GENERAL] Insert large number of records

> Even better would be if your bulkload could already be organised such > that all the data in the "temporary" table can indiscriminately be > inserted into the same target partition. That though depends a bit on > your setup - at some point the time saved at one end gets consumed on > the other

R: [GENERAL] Insert large number of records

Dear Alban, thank you for your precious reply, first of all. >> On 19 Sep 2017, at 15:47, Job wrote: >> >> Hi guys, >> >> we need to insert from a table to another (Postgresql 9.6.1) a large amount >> of data (about 10/20 millions of rows) without locking destination