Re: That EXPLAIN ANALYZE patch still needs work

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: That EXPLAIN ANALYZE patch still needs work
Дата
Msg-id 1590.1149801686@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: That EXPLAIN ANALYZE patch still needs work  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
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.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: That EXPLAIN ANALYZE patch still needs work
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: ADD/DROP INHERITS