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