X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 20139D1EC68 for ; Wed, 3 Mar 2004 21:38:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95438-03 for ; Wed, 3 Mar 2004 17:38:04 -0400 (AST) Received: from COLSWEEPER.cranel.com (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 49E7BD1EC6D for ; Wed, 3 Mar 2004 17:37:52 -0400 (AST) Received: from colmail01.cranel.com (colmail01.cranel.com) by COLSWEEPER.cranel.com (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Wed, 3 Mar 2004 16:37:08 -0500 Received: from cranel.com (gspiegelberg.cranel.com [192.168.11.134]) by colmail01.cranel.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id GCWBC0VF; Wed, 3 Mar 2004 16:41:54 -0500 Message-ID: <4046502C.7090307@cranel.com> Date: Wed, 03 Mar 2004 16:37:48 -0500 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Vivek Khera Cc: pgsql-performance@postgresql.org Subject: Re: Bulk INSERT performance in 7.4.1 References: <20040303092528.GA6647@deneb.enyo.de> <20040303141032.GA12276@deneb.enyo.de> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/48 X-Sequence-Number: 5904 Would turning autocommit off help? Vivek Khera wrote: >>>>>>"FW" == Florian Weimer writes: > > > FW> After increasing the number of checkpoint segments and the shared-memory > FW> buffers, performance is back to the expected levels. It might even be a > FW> bit faster. > > If you've got the time, could you try also doing the full bulk insert > test with the checkpoint log files on another physical disk? See if > that's any faster. > -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@Cranel.com Cranel. Technology. Integrity. Focus.