Re: That EXPLAIN ANALYZE patch still needs work

Simon Riggs wrote:
> On Thu, 2006-06-08 at 17:21 -0400, Tom Lane wrote:
> > Alvaro Herrera <alvherre@commandprompt.com> writes:
> > > Tried on two machines.  The first (Turion64 laptop) gives 44-45 ms for
> > > the SELECT, and 50-51 ms for the EXPLAIN ANALYZE.
> > 
> > > 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.
> > 
> > Do you have oprofile installed on these?  Comparing oprofile results
> > might give some more insight where the time is going.
> 
> On my office PC the overhead from EA is about 20%.

Can you please run the test program in this thread, if you are running
Linux?

http://marc.theaimsgroup.com/?l=linux-kernel&m=114297656924494&w=2

The machine I reported to show the problem says

# ./a.out 0xe408
0
./a.out: Detect PM-Timer Bug

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