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
|
Список | 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 по дате отправления: