Re: [PERFORM] Blocking every 20 sec while mass copying.

2014-07-23 Thread Benjamin Dugast
many maintenance on the database. Thanks for all answer that you give us. 2014-07-21 10:02 GMT+02:00 Albe Laurenz : > Please keep the list on CC: in your responses. > > Benjamin Dugast wrote: > > 2014-07-18 13:11 GMT+02:00 Albe Laurenz : > >> This sounds a lot li

[PERFORM] Blocking every 20 sec while mass copying.

2014-07-18 Thread Benjamin Dugast
Hello, I'm working on Postgres 9.3.4 for a project. We are using Scala, Akka and JDBC to insert data in the database, we have around 25M insert to do which are basically lines from 5000 files. We issue a DELETE according to the file (mandatory) and then a COPY each 1000 lines of that file. *DELE