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 */
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-05-19 23:45:01|
|Subject: Re: Optimizing for writes. Data integrity not critical |
|Previous:||From: Steve Bergman||Date: 2005-05-19 22:21:07|
|Subject: Optimizing for writes. Data integrity not critical|