Tom Lane wrote:
"Merlin Moncure" <mmoncure@xxxxxxxxx> writes:your time of 150 ms is looking like the slow case on my results.Yeah... so what's wrong with my test? Anyone else care to duplicate the test and see what they get?
Using your test [generating c from int(rand(1000))], I get 230 ms using 5.0.18 on a P3 1000 Mhz (doing optimize table on t made no difference at all).
Cheers Mark