Re: That EXPLAIN ANALYZE patch still needs work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Date: 2006-06-09 13:34:39
Message-ID: 9238.1149860079@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2006-06-09 13:39:37 Re: That EXPLAIN ANALYZE patch still needs work
Previous Message Roman Neuhauser 2006-06-09 13:33:31 Re: Fabian Pascal and RDBMS deficiencies in fully implementing