Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 13E199FB56E for ; Tue, 31 Oct 2006 17:43:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 56670-01-2 for ; Tue, 31 Oct 2006 21:42:49 +0000 (UTC) X-Greylist: delayed 00:30:19.423344 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id ACA169FB613 for ; Tue, 31 Oct 2006 17:34:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from lou-bada.torma.org (lou-bada.torma.org [213.41.244.89]) by svr4.postgresql.org (Postfix) with ESMTP id 0515B5AF02A for ; Tue, 31 Oct 2006 21:04:01 +0000 (GMT) Received: from lara.torma.org (lara.lou-bada.torma.org [10.7.3.65]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by lou-bada.torma.org (Postfix) with ESMTP id 5CA9659401 for ; Tue, 31 Oct 2006 22:03:59 +0100 (CET) From: Teemu Torma To: pgsql-performance@postgresql.org Subject: Re: Best COPY Performance Date: Tue, 31 Oct 2006 22:03:57 +0100 User-Agent: KMail/1.9.4 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200610312203.57553.teemu@torma.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=BAYES_05, SPF_FAIL X-Spam-Level: X-Archive-Number: 200610/634 X-Sequence-Number: 21763 On Tuesday 31 October 2006 21:11, Worky Workerson wrote: > One thing which I never mentioned was that I > am using ext3 mounted with noatime,data=writeback. You might also want to try with data=ordered. I have noticed that nowadays it seems to be a bit faster, but not much. I don't know why, maybe it has got more optimization efforts. Teemu