Re: good pc but bad performance,why?

From: Richard Huxton <dev(at)archonet(dot)com>
To: huang yaqin <hyq(at)gthome(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: good pc but bad performance,why?
Date: 2004-04-06 11:16:22
Message-ID: 200404061216.22856.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tuesday 06 April 2004 09:01, 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?

How have you tuned your postgresql.conf file?
What disk systems do you have?
What does vmstat/iostat show as the bottleneck in the system?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2004-04-06 12:46:49 Re: good pc but bad performance,why?
Previous Message huang yaqin 2004-04-06 08:01:34 good pc but bad performance,why?