Re: Hardware spec

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Hardware spec
Дата
Msg-id 82k5r3op0o.fsf@mid.bfk.de
обсуждение исходный текст
Ответ на Re: Hardware spec  (Willo van der Merwe <willo@mirasol.co.za>)
Ответы Re: Hardware spec  (Willo van der Merwe <willo@mirasol.co.za>)
Список pgsql-performance
* Willo van der Merwe:

> Good advice. After running a vmstat and iostat, it is clear, to my
> mind anyway, that the most likely bottleneck is IO, next is probably
> some more RAM.

> Here's the output:
> procs -----------memory---------- ---swap-- -----io---- --system--
> ----cpu----
> r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us
> sy id wa
> 0  0  29688  80908 128308 3315792    0    0     8    63    6     8 17
> 2 80  1

You need to run "vmstat 10" (for ten-second averages) and report a
couple of lines.

> avg-cpu:  %user   %nice    %sys %iowait   %idle
>          17.18    0.00    1.93    0.81   80.08

Same for iostat.

Your initial numbers suggest that your server isn't I/O-bound, though
(the percentage spent in iowait is much too small, and so are the tps
numbers).

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: utilising multi-cpu/core machines?
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: Hardware spec