Re: external sort performance

От: Jeremy Harris
Тема: Re: external sort performance
Дата: ,
Msg-id: 4EC926C9.1030409@wizmail.org
(см: обсуждение, исходный текст)
Ответ на: Re: external sort performance  (Jon Nelson)
Список: pgsql-performance

Скрыть дерево обсуждения

external sort performance  (Jon Nelson, )
 Re: external sort performance  (Claudio Freire, )
  Re: external sort performance  (Jon Nelson, )
   Re: external sort performance  (Jon Nelson, )
    Re: external sort performance  (Tom Lane, )
    Re: external sort performance  (Josh Berkus, )
 Re: external sort performance  (Craig James, )
 Re: external sort performance  (Tom Lane, )
 Re: external sort performance  (Jeremy Harris, )
  Re: external sort performance  (Jon Nelson, )
   Re: external sort performance  (Jeremy Harris, )

On 2011-11-20 15:00, Jon Nelson wrote:
>  Do you happen to recall if disk I/O is
> counted as user or system time?

Neither, traditionally.  Those times are cpu times;
they only account for what the cpu was doing.
The disks could be working in parallel as a result
of cpu actions, and probably were - but the software
found work to do for the cpu.   You'd want to be
looking at iostat during the run to see how busy the
disks were.

As to why it takes 16 hours cpu to do the external
version but only 34 minutes for internal - some of that
will be down to data-shuffling in- and out- of disk files
which is nonetheless accounted to user-mode cpu time,
but some will be the plain inefficiency of the external
version having to effectively do work over many times
because it can't have a complete view of the problem at
hand at any one time.

--
Jeremy


В списке pgsql-performance по дате сообщения:

От: Jeremy Harris
Дата:
Сообщение: Re: external sort performance
От: Rauan Maemirov
Дата:
Сообщение: Re: Problems with FTS