I wrote: > ... and see how the patch does that way? BTW, please do look at "vmstat 1" while running the test case corresponding to your number of processors. It's hard to tell from the runtime alone whether the patch is fully accomplishing its goal of reducing wasted cycles. If you see user CPU percent go to 100 and context swaps drop to a low value, though, you know it's working.
regards, tom lane ---------------------------(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