Postgres Pro
Downloads
Home   >   mailing lists

Re: good pc but bad performance,why? - Mailing list pgsql-performance

From Tom Lane
Subject Re: good pc but bad performance,why?
Date
Msg-id 25241.1081266129@sss.pgh.pa.us
Whole thread Raw
In response to good pc but bad performance,why?  (huang yaqin <hyq@gthome.com>)
List pgsql-performance
Tree view 
huang yaqin <hyq@gthome.com> 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

pgsql-performance by date:

Previous
From: "Andrew Matthews"
Date:
Subject: Wierd issues
Next
From: "Jim C. Nasby"
Date:
Subject: Re: possible improvement between G4 and G5