| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'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:39:37 |
| Message-ID: | 007801c68bca$26d58560$0202fea9@aus.pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> 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.)
>
Does my post from yesterday (39ms without explain analyze, 280+ with explain
analyze)
on FreeBSD/amd64, Dual Xeon's in HTT mode help?
What can I do to further the investigation?
It has 8.1.4 on it.
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron Bingham | 2006-06-09 13:55:04 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing |
| Previous Message | Tom Lane | 2006-06-09 13:34:39 | Re: That EXPLAIN ANALYZE patch still needs work |