Postgres Pro
Downloads
Home   >   mailing lists

Re: That EXPLAIN ANALYZE patch still needs work - Mailing list pgsql-hackers

From Tom Lane
Subject Re: That EXPLAIN ANALYZE patch still needs work
Date
Msg-id 9238.1149860079@sss.pgh.pa.us
Whole thread Raw
In response to Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: That EXPLAIN ANALYZE patch still needs work  ("Larry Rosenman" <ler@lerctr.org>)
Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> 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.)
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Next
From: "Larry Rosenman"
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work