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 B1A65D1EB28 for ; Tue, 6 Apr 2004 12:42:15 -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 01203-06 for ; Tue, 6 Apr 2004 12:42:14 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 57AE4D1E146 for ; Tue, 6 Apr 2004 12:42:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i36Fg95R025242; Tue, 6 Apr 2004 11:42:09 -0400 (EDT) To: huang yaqin Cc: "pgsql-performance@postgresql.org" Subject: Re: good pc but bad performance,why? In-reply-to: <0HVQ00E33PI95I@mail.gthome.com> References: <0HVQ00E33PI95I@mail.gthome.com> Comments: In-reply-to huang yaqin message dated "Tue, 06 Apr 2004 16:01:34 +0800" Date: Tue, 06 Apr 2004 11:42:09 -0400 Message-ID: <25241.1081266129@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/64 X-Sequence-Number: 6364 huang yaqin writes: > 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? If the cheap machine appears to be able to commit more transactions per second than the better one, it's very likely because the cheap machine has a disk that lies about write completion. Is the server using SCSI disks by any chance? To a first approximation, IDE drives lie by default, SCSI drives don't. regards, tom lane