Alan McKay wrote:
Hey folks, We did 4 tests, upping the load each time. The 3rd and 4th ones have all 8 cores pegged at about 95%. Yikes! In the first test the processor running queue spikes at 7 and maybe averages 4 or 5 In the last test it spikes at 33 with an average maybe 25. Looks to me like it could be a CPU bottleneck. But I'm new at this :-) Is there a general rule of thumb "if queue is longer than X, it is likely a bottleneck?" In reading an IBM Redbook on Linux performance, I also see this : "High numbers of context switches in connection with a large number of interrupts can signal driver or application issues." On my first test where the CPU is not pegged, context switching goes from about 3700 to about 4900, maybe averaging 4100
Well the people here will need allot more information to figure out what is going on. What kind of Stress did you do???? is it a specific query causing the problem in the test
What kind of load? How many simulated clients How big is the database? Need to see the postgresql.config What kind of IO Subsystem do you have ??? what does vmstat show have you look at wiki yet http://wiki.postgresql.org/wiki/Performance_Optimization -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
