| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:13:18 |
| Message-ID: | 20060609131318.GD19659@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> On Thu, 2006-06-08 at 17:21 -0400, Tom Lane wrote:
> > Alvaro Herrera <alvherre(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Neuhauser | 2006-06-09 13:33:31 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing |
| Previous Message | Alvaro Herrera | 2006-06-09 12:54:13 | Re: That EXPLAIN ANALYZE patch still needs work |