Tom Lane <[EMAIL PROTECTED]> writes: > It's not so much that I want to inflate the measurements, as that > leaving 10% of the CPU on the table reduces pgbench's usefulness as > a way of stress-testing the backend.
I suspect the difference is the same thing you theorised made the difference before. Namely that they're no longer proceeding in lockstep. The progress is more random allowing some processes to make more progress than average and benefit from better, er, well some cache somewhere. In any case it seems like there would be cases where each kind of behaviour would be useful. It seems likely there would be bugs where the lockstep behaviour was useful for testing, and other bugs where the randomized behaviour would be useful for testing too. -- greg ---------------------------(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