Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing for writes. Data integrity not critical - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Optimizing for writes. Data integrity not critical
Date
Msg-id 20050519222731.GB20142@uio.no
Whole thread Raw
In response to Optimizing for writes. Data integrity not critical  (Steve Bergman <steve@rueb.com>)
Responses Re: Optimizing for writes. Data integrity not critical
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: Steve Bergman
Date:
Subject: Optimizing for writes. Data integrity not critical
Next
From: Tom Lane
Date:
Subject: Re: Optimizing for writes. Data integrity not critical