On May 21, 2006, at 12:23, Josh Berkus wrote:
Well, per our conversation the approach doesn't really work. EXECUTE
'string' + generate_series seems to carry a substantial and
somewhat random
overhead, between 100ms and 200ms -- enough to wipe out any
differences
between queries.
Per our
DW,
> The idea of the control is, of course, to subtract the overhead of
> the benchmarking function from the code actually being tested. So I
> guess my question is, how important is it to have the control there,
> and, if it is important, how should it actually work?
Well, per our convers
Fellow PostgreSQLers,
With a bit of guidance from Klint Gore, Neil Conway, Josh Berkus, and
Alexey Dvoychenkov, I have written a PL/pgSQL function to help me
compare the performance between different functions that execute the
same task. I've blogged the about the function here:
http://