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 258A6D1C951 for ; Tue, 6 Apr 2004 13:23:08 -0300 (ADT) 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 20467-09 for ; Tue, 6 Apr 2004 13:23:05 -0300 (ADT) Received: from cronos.madness.at (madness.at [213.153.61.104]) by svr1.postgresql.org (Postfix) with ESMTP id 9A98CD1BAFC for ; Tue, 6 Apr 2004 13:23:04 -0300 (ADT) Received: from masterbrain.kaltenbrunner.cc ([195.70.118.74] helo=madness.at) by cronos.madness.at with asmtp (TLSv1:AES256-SHA:256) (Exim 4.30) id 1BAtLn-0006hY-0I; Tue, 06 Apr 2004 18:22:59 +0200 Message-ID: <4072D959.5090905@madness.at> Date: Tue, 06 Apr 2004 18:22:49 +0200 From: Stefan Kaltenbrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7b) Gecko/20040326 X-Accept-Language: en-us, en MIME-Version: 1.0 To: huang yaqin Cc: pgsql-performance@postgresql.org Subject: Re: good pc but bad performance,why? References: <0HVQ00E33PI95I@mail.gthome.com> In-Reply-To: <0HVQ00E33PI95I@mail.gthome.com> 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: 200404/68 X-Sequence-Number: 6368 huang yaqin wrote: > hello, > > I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 . > I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance. This is most likely a dual processor Xeon machine with HT, because the x335 is limited to two physical cpus. > I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M RAM), can anyone give me some advice? any chance you are using the onboard MPT-Fusion "Raid"controller with a RAID1 - we have seen absolutely horrible performance from these controllers here. Using them as a normal SCSI-Controller with Softwareraid on top fixed this for us ... stefan