Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 774759FB3AE for ; Tue, 31 Oct 2006 16:16:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16513-01 for ; Tue, 31 Oct 2006 16:16:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exprod6og52.obsmtp.com (exprod6og52.obsmtp.com [64.18.1.185]) by postgresql.org (Postfix) with SMTP id 5095A9FB3A5 for ; Tue, 31 Oct 2006 16:16:41 -0400 (AST) Received: from source ([63.240.6.44]) by exprod6ob52.postini.com ([64.18.5.12]) with SMTP; Tue, 31 Oct 2006 12:16:38 PST Received: from 172.16.1.114 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Tue, 31 Oct 2006 15:16:27 -0500 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by d01smtp07.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 31 Oct 2006 15:16:26 -0500 Received: from 208.54.15.1 ([208.54.15.1]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.134]) with Microsoft Exchange Server HTTP-DAV ; Tue, 31 Oct 2006 20:16:26 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Tue, 31 Oct 2006 12:16:24 -0800 Subject: Re: Best COPY Performance From: "Luke Lonergan" To: "Worky Workerson" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Best COPY Performance Thread-Index: Acb9KW/urkptKWkcEduBWQAWy4o9DA== In-Reply-To: MIME-Version: 1.0 X-OriginalArrivalTime: 31 Oct 2006 20:16:26.0895 (UTC) FILETIME=[71A7D9F0:01C6FD29] X-WSS-ID: 695970912TS7682467-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/628 X-Sequence-Number: 21757 Worky (!), On 10/31/06 12:11 PM, "Worky Workerson" 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