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 conversation I eliminated the EXECUTE 'string' +
generate_series. Check it out.
http://theory.kineticode.com/computers/databases/postgresql/
benchmarking_functions.html
(Temporary URL; justatheory.com seems to have disappeared from DNS...
Best,
David
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
