Re: Optimizing for writes. Data integrity not critical

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/