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 D7036D1EA31 for ; Wed, 3 Mar 2004 20:51:10 +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 85406-06 for ; Wed, 3 Mar 2004 16:51:09 -0400 (AST) Received: from lorax.kcilink.com (lorax.kcilink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 31522D1E9FB for ; Wed, 3 Mar 2004 16:51:02 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id CFA613E3D for ; Wed, 3 Mar 2004 15:28:56 -0500 (EST) Received: from lorax.kcilink.com ([127.0.0.1]) by localhost (lorax.kcilink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 29249-02 for ; Wed, 3 Mar 2004 15:28:56 -0500 (EST) Received: from lorax.kcilink.com (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id 3A8D33E37 for ; Wed, 3 Mar 2004 15:28:56 -0500 (EST) Received: (from news@localhost) by lorax.kcilink.com (8.12.9p2/8.12.9/Submit) id i23KSriE007332 for pgsql-performance@postgresql.org; Wed, 3 Mar 2004 15:28:53 -0500 (EST) (envelope-from news) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: Bulk INSERT performance in 7.4.1 Date: Wed, 03 Mar 2004 15:28:53 -0500 Organization: Khera Communications, Inc., Rockville, MD Lines: 15 Message-ID: References: <20040303092528.GA6647@deneb.enyo.de> <20040303141032.GA12276@deneb.enyo.de> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kcilink.com 1078345733 31516 65.205.34.180 (3 Mar 2004 20:28:53 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Wed, 3 Mar 2004 20:28:53 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, berkeley-unix) Cancel-Lock: sha1:1MwEZB8dZ6/idnkMwGiZSPuhMx4= X-Virus-Scanned: by amavisd-new at kcilink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/45 X-Sequence-Number: 5901 >>>>> "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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/