Re: [GENERAL] Performance of batch COMMIT

2005-12-19 Thread Jim C. Nasby
On Mon, Dec 19, 2005 at 11:44:15AM -0800, Benjamin Arai wrote: > Each week I have to update a very large database. Currently I run a commit > about every 1000 queries. This vastly increased performance but I am > wondering if the performance can be increased further. I could send all of > the q

[GENERAL] Performance of batch COMMIT

2005-12-19 Thread Benjamin Arai
Each week I have to update a very large database.  Currently I  run a commit about every 1000 queries.  This vastly increased performance but I am wondering if the performance can be increased further.  I could send all of the queries to a file but COPY doesn't support plain queries such as