I'm trying to find a way to speedup population of my db.
I'd like to use
COPY as suggested here, but I have only access to my db, not to the entire server. All other tips worked good for me, but unfortunately I need another speedup now.
So now I'm using just an
INSERT ... VALUES without autocommit or any constraints.
Maybe I'm totally wrong, but I noticed that when I'm trying to execute lesser number of queries with more values in VALUES, population goes faster.
So I'd like to know what is the query length limit (or VALUES parameters limit).