Re: Hardware spec

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: Willo van der Merwe <willo(at)mirasol(dot)co(dot)za>
Cc: Jean-David Beyer <jeandavid8(at)verizon(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware spec
Date: 2007-09-06 14:19:03
Message-ID: 82k5r3op0o.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bfk(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Willo van der Merwe 2007-09-06 14:33:00 Re: Hardware spec
Previous Message Kevin Grittner 2007-09-06 13:46:40 Re: utilising multi-cpu/core machines?