Simon Riggs wrote: > On Thu, 2006-06-08 at 17:21 -0400, Tom Lane wrote: > > Alvaro Herrera <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
