| From: | Stefan Kaltenbrunner <mm-mailinglist(at)madness(dot)at> |
|---|---|
| To: | huang yaqin <hyq(at)gthome(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: good pc but bad performance,why? |
| Date: | 2004-04-06 16:22:49 |
| Message-ID: | 4072D959.5090905@madness.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-04-06 18:52:17 | Re: possible improvement between G4 and G5 |
| Previous Message | Jim C. Nasby | 2004-04-06 15:52:35 | Re: possible improvement between G4 and G5 |