Re: external sort performance

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: external sort performance
Дата
Msg-id 4EC906FE.5040902@wizmail.org
обсуждение исходный текст
Ответ на external sort performance  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: external sort performance  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-performance
On 2011-11-17 17:10, Jon Nelson wrote:
> external sort ended, 7708696 disk blocks used: CPU 359.84s/57504.66u
> sec elapsed 58966.76 sec
>
> Am I to understand that the CPU portion of the sorting only took 6
> minutes but the sort itself took almost 16.5 hours and used approx
> 60GB of disk space?


I realise you've had helpful answers by now, but.... that reads
as 16 hours of cpu time to me; mostly user-mode but with 6 minute
of system-mode.  98% cpu usage for the 16 hours elapsed.

--
Jeremy

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Benchmarking tools, methods
Следующее
От: Jon Nelson
Дата:
Сообщение: Re: external sort performance