Re: Best COPY Performance

["Luke Lonergan" <llonergan(at)greenplum(dot)com>]

Worky (!),

On 10/31/06 12:11 PM, "Worky Workerson" <worky(dot)workerson(at)gmail(dot)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