| From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
|---|---|
| To: | "Gerhard Wohlgenannt" <wohlg(at)ai(dot)wu(dot)ac(dot)at> |
| Cc: | "Andy Colson" <andy(at)squeakycode(dot)net>, "Tomas Vondra" <tv(at)fuzzy(dot)cz>, pgsql-performance(at)postgresql(dot)org, "Heinz-Peter Lang" <heinz(at)langatium(dot)net>, "Gerhard Wohlgenannt" <wohlg(at)ai(dot)wu-wien(dot)ac(dot)at>, "Weichselbraun, Albert" <albert(dot)weichselbraun(at)wu(dot)ac(dot)at> |
| Subject: | Re: Sudden drop in DBb performance |
| Date: | 2011-09-05 14:39:30 |
| Message-ID: | cc2305e664bc05f72ce55eaf7c18db63.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pasman pasmański | 2011-09-05 15:14:14 | Re: Rather large LA |
| Previous Message | Gerhard Wohlgenannt | 2011-09-05 14:15:27 | Re: Sudden drop in DBb performance |