Carlo Stonebanks wrote: > <<Actually it's quite possible that > that extra overhead in nested loop is largely gettimeofday() calls for the > explain analyze. Does the query take less time run without explain analyze > than it does run with it? >>> > > Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query > is a symptom of time being lost to a function call?
It means that measuring alters the reality. -- Alvaro Herrera http://www.flickr.com/photos/alvherre/ "I must say, I am absolutely impressed with what pgsql's implementation of VALUES allows me to do. It's kind of ridiculous how much "work" goes away in my code. Too bad I can't do this at work (Oracle 8/9)." (Tom Allison) http://archives.postgresql.org/pgsql-general/2007-06/msg00016.php ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
