Re: good pc but bad performance,why?

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