On Thu, May 19, 2005 at 05:21:07PM -0500, Steve Bergman wrote: > I'm doing the writes individually. Is there a better way? Combining > them all into a transaction or something?
Batching them all in one or a few transactions will speed it up a _lot_. Using COPY would help a bit more on top of that. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster