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 07E8CD1D4DA for ; Tue, 6 Apr 2004 09:46:06 -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 15832-08 for ; Tue, 6 Apr 2004 09:46:51 -0300 (ADT) Received: from internet.potentialtech.com (h-66-167-251-6.phlapafg.covad.net [66.167.251.6]) by svr1.postgresql.org (Postfix) with ESMTP id CEBC2D1D391 for ; Tue, 6 Apr 2004 09:46:03 -0300 (ADT) Received: from potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id 48BBA69A71; Tue, 6 Apr 2004 08:46:51 -0400 (EDT) Message-ID: <4072A6B9.5050502@potentialtech.com> Date: Tue, 06 Apr 2004 08:46:49 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 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 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/59 X-Sequence-Number: 6359 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. > I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M RAM), can anyone give me some advice? Have you referenced this document?: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html -- Bill Moran Potential Technologies http://www.potentialtech.com