Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: That EXPLAIN ANALYZE patch still needs work
Date
Msg-id 20060609125412.GC19659@surnet.cl
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Alvaro Herrera wrote:

> The second machine, desktop Celeron 533, gives 197-200 ms for the SELECT
> and 788-790 for the EXPLAIN ANALYZE.  I guess this is the reproduction
> you were looking for.

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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: Re: Going for 'all green' buildfarm results
Next
From: Alvaro Herrera
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work