From: Tomas Vondra <tv@fuzzy.cz>
To: Gerhard Wohlgenannt <wohlg@ai.wu.ac.at>
Cc: Andy Colson <andy@squeakycode.net>
Cc: Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-performance@postgresql.org, "Heinz-Peter Lang" <heinz@langatium.net>
Cc: Gerhard Wohlgenannt <wohlg@ai.wu-wien.ac.at>
Cc: Weichselbraun, Albert <albert.weichselbraun@wu.ac.at>
Subject: Re: Sudden drop in DBb performance
Date: Mon, 5 Sep 2011 16:39:30 +0200
Message-ID: <cc2305e664bc05f72ce55eaf7c18db63.squirrel@sq.gransy.com> (raw)
In-Reply-To: <4E64D7EA.3010704@ai.wu.ac.at>
References: <4E61D6B4.9090804@ai.wu.ac.at>
<33fadeb6ac1bade5ef01bd08d1fd7807.squirrel@sq.gransy.com>
<4E64D3D3.8000205@squeakycode.net>
<4E64D7EA.3010704@ai.wu.ac.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz, wohlg@ai.wu.ac.at, andy@squeakycode.net, heinz@langatium.net, wohlg@ai.wu-wien.ac.at, albert.weichselbraun@wu.ac.at
Subject: Re: Sudden drop in DBb performance
In-Reply-To: <cc2305e664bc05f72ce55eaf7c18db63.squirrel@sq.gransy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox