Re: [HACKERS] A Better External Sort?

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: [HACKERS] A Better External Sort?
Дата
Msg-id 20051005094125.GW2241@mathom.us
обсуждение исходный текст
Ответ на Re: [HACKERS] A Better External Sort?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-performance
On Sat, Oct 01, 2005 at 06:19:41PM +0200, Martijn van Oosterhout wrote:
>COPY TO /dev/null WITH binary
>13MB/s    55% user 45% system  (ergo, CPU bound)
[snip]
>the most expensive. But it does point out that the whole process is
>probably CPU bound more than anything else.

Note that 45% of that cpu usage is system--which is where IO overhead
would end up being counted. Until you profile where you system time is
going it's premature to say it isn't an IO problem.

Mike Stone


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Query in SQL statement
Следующее
От: Michael Stone
Дата:
Сообщение: Re: [HACKERS] A Better External Sort?