Comment Re:Mod parent way up! (Score 1) 275
Have you considered using the PostgreSQL COPY function? It is about an order of magnitude faster then INSERT. The only caveat is that even COPY needs to update INDEXes if you have any, so with many indexes, you will see a more modest improvement.