On 5 Září 2011, 16:08, Gerhard Wohlgenannt wrote:
> Below please find the results of vmstat 2 over some periode of time ..
> with normal database / system load.
What does a "normal load" mean? Does that mean a time when the queries are
slow?
Are you sure the machine really has 48GB of RAM? Because from the vmstat
output it seems like there's just 32GB.
procs -----------memory---------- ---swap-- -----io---- -system--
----cpu----
r b swpd free buff cache si so bi bo in cs us sy
id wa
0 0 1342168 336936 107636 31353512 0 0 14 183 1911 3426
2 1 93 4
1342168 + 336936 + 107636 + 31353512 = 33140252 ~ 31GB
BTW there's 1.3GB of swap, although it's not used heavily (according to
the vmstat output).
Otherwise I don't see anything wrong in the output. What is the size of
the database (use pg_database_size to get it)? Did it grow significantly
recently?
Tomas