"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Do you have any numbers on how much performance increases with it?
A rough estimate is that it would cost more than half as much as EXPLAIN ANALYZE does: that imposes two extra syscalls per ExecProcNode, while this adds one. There are other high-frequency CHECK_FOR_INTERRUPTS calls that I can't quantify as easily. My guess is that it's costing us less than a factor of 2, but well more than 10%, on typical queries ... so definitely worth fixing for 8.1 if we can convince ourselves it's correct. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings