David Mitchell wrote:
> What is the load average on this machine? Do you do many updates? If
> you do a lot of updates, perhaps you haven't vacuumed recently. We
> were seeing similar symptoms when we started load testing our stuff
> and it turned out we were vacuuming too infrequently.
The load average at the 100% utilization point was about 30! A vacuum
analyze was done before the test was started. I believe there are many
more selects than updates happening at any one time.
Dennis