From: Andy Colson <andy@squeakycode.net>
To: Tomas Vondra <tv@fuzzy.cz>
Cc: Gerhard Wohlgenannt <wohlg@ai.wu.ac.at>
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, 05 Sep 2011 10:17:42 -0500
Message-ID: <4E64E816.80905@squeakycode.net> (raw)
In-Reply-To: <cc2305e664bc05f72ce55eaf7c18db63.squirrel@sq.gransy.com>
References: <4E61D6B4.9090804@ai.wu.ac.at>
<33fadeb6ac1bade5ef01bd08d1fd7807.squirrel@sq.gransy.com>
<4E64D3D3.8000205@squeakycode.net>
<4E64D7EA.3010704@ai.wu.ac.at>
<cc2305e664bc05f72ce55eaf7c18db63.squirrel@sq.gransy.com>
On 09/05/2011 09:39 AM, Tomas Vondra wrote:
> 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
>
Yeah, its interesting that it swapped in memory, but never out. Looking at this vmstat, it does not look like a hardware problem.(Assuming "normal load" means slow queries)
> Did it grow significantly recently?
That's a good thought, maybe the stats are old and you have bad plans? It could also be major updates to the data too (as opposed to growth).
Gerhard, have you done an 'explain analyze' on any of your slow queries? Have you done an analyze lately?
-Andy
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: andy@squeakycode.net, tv@fuzzy.cz, wohlg@ai.wu.ac.at, heinz@langatium.net, wohlg@ai.wu-wien.ac.at, albert.weichselbraun@wu.ac.at
Subject: Re: Sudden drop in DBb performance
In-Reply-To: <4E64E816.80905@squeakycode.net>
* 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