Re: System Load analyze

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: System Load analyze
Дата
Msg-id Pine.GSO.4.64.0711280356190.20935@westnet.com
обсуждение исходный текст
Ответ на System Load analyze  (Peter Bauer <peter.bauer@apus.co.at>)
Ответы Re: System Load analyze
Список pgsql-general
On Sat, 24 Nov 2007, Peter Bauer wrote:

> top shows that the CPUs are at least 80% idle most of the time so i
> think there is an I/O bottleneck.

top also shows that you're never waiting for I/O which is usually evidence
there isn't an I/O bottleneck.  You passed along most of the right data,
but some useful additional things to know are:

-Actual brand/model of SCSI controller
-Operating system
-What time interval the vmstat and iostat information you gave were
produced at.

I agree with Scott that checkpoints should be considered as a possibility
here.  I'd suggest you set checkpoint_warning to a high value so you get a
note in the logs every time one happens, then see if those happen at the
same time as your high load average.  More on that topic and how to adjust
the background writer if that proves to be the cause of your slowdown is
at http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Linux v.s. Mac OS-X Performance
Следующее
От: "zanet_tomas\@libero\.it"
Дата:
Сообщение: PostgreSQL DB split