We're running 8.1beta3 on one server and are having ridiculous performance
issues. This is a 2 cpu Opteron box and both processors are staying at 98
or 99% utilization processing not-that-complex queries. Prior to the
upgrade, our I/O wait time was about 60% and cpu utilization rarely got very
high, now I/O wait time is at or near zero.
I'm planning to go back to 8.0 tonight or tomorrow night but thought I'd
check the pqsql-performance prophets before I gave it up.
pgsql-performance by date
|Next:||From: mark||Date: 2005-10-31 23:57:09|
|Subject: Re: 8.x index insert performance|
|Previous:||From: Tom Lane||Date: 2005-10-31 21:18:47|
|Subject: Re: 8.x index insert performance |