Re: [HACKERS] External Sort timing debug statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] External Sort timing debug statements
Дата
Msg-id 3551.1128397878@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] External Sort timing debug statements  (Greg Stark <gsstark@mit.edu>)
Список pgsql-patches
Greg Stark <gsstark@mit.edu> writes:
> I'm not actually involved in this so maybe I'm completely off base here. But
> wouldn't you want to know how many tuples are being sorted and how many data
> are being written in these runs in order to be able to actually make sense of
> these timing measurements?

In all plausible test cases you should be able to know the total number
of tuples being sorted independently.  Counting the tuples processed in
each run would require extra per-tuple overhead, which I'd rather avoid
until proven necessary.

The total-data-volume aspect may or may not be interesting, not sure
yet.  Let's see what we can learn from the present low-impact patch.

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: [HACKERS] External Sort timing debug statements
Следующее
От: David Fetter
Дата:
Сообщение: Re: [HACKERS] Best practices: MERGE