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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
