Re: CPU load

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: CPU load
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C2028AA976@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: CPU load  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: CPU load  (kiki@fesb.hr)
Список pgsql-performance
> If that's what it looks like your server is running just fine.  Load
> of 1.31, 85+% idle, no wait time.  Or is that top and vmstat output
> from when the server is running fine?

Don't forget that there are 8 CPUs, and the backend will only run on one
of them.

But I concur that this seems ok.
How many rows are returned? Is 0.6 seconds an unacceptable time for that?

If there is a lot of sorting going on and the pages are residing in the
buffer, I would expect high CPU load.

Normally, I am quite happy if my database is CPU bound. I start worrying
if I/O wait grows too high.

Yours,
Laurenz Albe

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Slow updates, poor IO
Следующее
От: kiki@fesb.hr
Дата:
Сообщение: Re: CPU load