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