Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: good pc but bad performance,why?
Date
Msg-id 200404061216.22856.dev@archonet.com
Whole thread Raw
In response to good pc but bad performance,why?  (huang yaqin <hyq@gthome.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: huang yaqin
Date:
Subject: good pc but bad performance,why?
Next
From: Bill Moran
Date:
Subject: Re: good pc but bad performance,why?