Re: Best COPY Performance

llonergan@greenplum.com

From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Worky Workerson" <worky.workerson@gmail.com>
Cc: pgsql-performance@postgresql.org
Date: 2006-10-31T20:16:24Z
Lists: pgsql-performance
Worky (!),

On 10/31/06 12:11 PM, "Worky Workerson" <worky.workerson@gmail.com> wrote:

> Any recommendations on what to
> look at to find a fix?  One thing which I never mentioned was that I
> am using ext3 mounted with noatime,data=writeback.

You can try setting the max readahead like this:
  /sbin/blockdev --setra 16384 /dev/sd[a-z]

It will set the max readahead to 16MB for whatever devices are in
/dev/sd[a-z] for the booted machine.  You'd need to put the line(s) in
/etc/rc.d/rc.local to have the setting persist on reboot.

- Luke