Re: [PERFORM] Benchmarking Function

2006-05-21 Thread David Wheeler
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

Re: [PERFORM] Benchmarking Function

2006-05-21 Thread Josh Berkus
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

[PERFORM] Benchmarking Function

2006-05-19 Thread David Wheeler
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://