Re: Best COPY Performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Worky (!),

On 10/31/06 12:11 PM, "Worky Workerson" <worky.workerson@xxxxxxxxx> 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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux