Andrew Dunstan wrote:
As far as the test failure, maybe we are just not allowing enough time for the stats collector to run? The thing sits there for 2 sec, which theoretically is plenty, but it's a busy-wait loop and if the Cygwin scheduler is not aggressive about taking away timeslices then maybe the stats processes don't get to run. Try doing the test script by hand, with just a manual delay instead of the sleep function, and see if it passes.
Yes, when I do that it works. But even when I increase the interval to 30 secs the regression script fails. I tried to use a sleep function that didn't do a busy-wait loop, but plperl seems to segfault on this platform :-( What fun.
Further data point - the expected result appears when I set the sleep interval at 1 minute, but not at 40 secs. That does indicate that the stats collector is actually running and doing its job (kinda).
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend