Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Hmm, I take that back. I updated to the current CVS tip on this machine > > and now I don't see the problem. Without EXPLAIN ANALYZE, the times are > > around 115-117 ms. With EXPLAIN ANALYZE, 149-152ms. > > At the moment, CVS HEAD still has the sampling patch in it. You need to > be looking at 8.1, or HEAD from several weeks ago, to see the full > impact of gettimeofday-every-time. (I imagine Simon's strace count > is wrong for the same reason.)
Ok, then I re-retract, because the test I posted previously was done with 8.1. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match