Re: Best COPY Performance

Teemu Torma <teemu@torma.org>

From: Teemu Torma <teemu@torma.org>
To: pgsql-performance@postgresql.org
Date: 2006-10-31T21:03:57Z
Lists: pgsql-performance
On Tuesday 31 October 2006 21:11, Worky Workerson wrote:
> One thing which I never mentioned was that I
> am using ext3 mounted with noatime,data=writeback.

You might also want to try with data=ordered.  I have noticed that 
nowadays it seems to be a bit faster, but not much.  I don't know why, 
maybe it has got more optimization efforts.

Teemu