Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A0ECD475A98; Tue, 7 May 2002 21:25:40 -0400 (EDT) Received: from svana.org (svana.org [210.9.66.30]) by postgresql.org (Postfix) with ESMTP id E75CD475A61; Tue, 7 May 2002 21:25:37 -0400 (EDT) Received: from kleptog by svana.org with local (Exim 3.12 #1 (Debian)) id 175GCt-0004ct-00; Wed, 08 May 2002 11:25:27 +1000 Date: Wed, 8 May 2002 11:25:27 +1000 From: Martijn van Oosterhout To: "Samuel J. Sutjiono" Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Performance issues with compaq server Message-ID: <20020508112527.A17584@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: "Samuel J. Sutjiono" , pgsql-general@postgresql.org, pgsql-sql@postgresql.org References: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com>; from ssutjiono@wc-group.com on Tue, May 07, 2002 at 06:40:32PM -0400 X-Archive-Number: 200205/282 X-Sequence-Number: 24262 On Tue, May 07, 2002 at 06:40:32PM -0400, Samuel J. Sutjiono wrote: > I tried to load data using insert statement to our new database server > (Compaq DL580, DL590, DL380 using SCSI driver) but it was very very slow. > The database runs on Red Hat Linux 7.2 and PostgreSQL version 7.1.3 > > Does anybody know any idea to what cause this problem ? or things that I > need to look or check (in the config. file) Put them in a trasaction (begin/commit). Without that, each insert becomes it's own transaction which is rather expensive. Postgresql 7.2 improves this a bit but the transaction will help anyway. HTH, -- Martijn van Oosterhout http://svana.org/kleptog/ > Canada, Mexico, and Australia form the Axis of Nations That > Are Actually Quite Nice But Secretly Have Nasty Thoughts About America