Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3C9A3476294 for ; Thu, 9 May 2002 09:05:04 -0400 (EDT) Received: from edinet.it (unknown [195.223.174.3]) by postgresql.org (Postfix) with SMTP id 2BC014762E1 for ; Thu, 9 May 2002 08:29:57 -0400 (EDT) Received: (qmail 9736 invoked by uid 505); 9 May 2002 12:29:53 -0000 Received: from proxy.edinet.it (127.0.0.1) by proxy.edinet.it with SMTP; 9 May 2002 12:29:50 -0000 Subject: Re: Performance issues with compaq server From: Denis Gasparin To: "Samuel J. Sutjiono" Cc: Postgresql General Mailing List , pgsql-sql@postgresql.org In-Reply-To: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com> References: <001501c1f618$32d0d780$110a010a@headquarters.wcgroup.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2-5mdk Date: 09 May 2002 14:29:50 +0200 Message-Id: <1020947390.2035.3.camel@edspctec12> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS perl-11 X-Archive-Number: 200205/319 X-Sequence-Number: 24299 The Compaq servers you indicated use the smart array controller which is very very slow in storing data into hard disks. Are you using the RAID? I suggest you to buy a controller with a larger write cache (the smart array controller does not have w-cache)... You should note a large performance progress... Also do not forget to set fsync to false and to use the COPY command whenever is possible... Bye! -- Doct. Eng. Denis Gasparin: denis@edistar.com --------------------------- Programmer & System Administrator - Edistar srl Il mer, 2002-05-08 alle 00:40, Samuel J. Sutjiono ha scritto: > 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) > > I appreciate any help. > > Regards, > Samuel