Re: Optimizing for writes. Data integrity not critical

"Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com> writes:
> 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.

Also, if you really don't need to worry about data integrity, turning
off fsync in the config file will probably help. (Though since it's
an IDE drive, maybe not, as the drive may be lying about write complete
anyway.)

Increasing checkpoint_segments will help too, at the cost of disk space
(about 32MB per increment in the value, IIRC). I'd suggest pushing it
up enough so you don't incur a checkpoint while the time-critical
operation runs. checkpoint_timeout may be too small too.

regards, tom lane