From: adrien ducos <aducos@hbs-research.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: My server is oddly very slow
Date: Fri, 06 May 2011 09:55:34 +0200
Message-ID: <4DC3A976.7050707@hbs-research.com> (raw)
In-Reply-To: <4DC29710020000250003D300@gw.wicourts.gov>
References: <4DC17AAB.1080206@hbs-research.com>
<4DC14AA6020000250003D28B@gw.wicourts.gov>
<4DC275A8.8000400@hbs-research.com>
<4DC29710020000250003D300@gw.wicourts.gov>
Kevin Grittner a écrit :
> adrien ducos <aducos@hbs-research.com> wrote:
>
>> Kevin Grittner a écrit :
>>
>
>
>>> What does this show?:
>>>
>>> free -m
>>>
>
>
>> total used free shared buffers cached
>> Mem: 3042 3000 41 0 4 2896
>> -/+ buffers/cache: 99 2942
>> Swap: 1983 1 1982
>>
>
> This was while the PostgreSQL server was running and showing
> shared_buffers = 512MB? If so, there's something seriously wrong
> with your OS.
>
>
>>> The first line in vmstat (which is all you get if you run it
>>> without a number) is averages since the OS was booted. That's
>>> not usually very helpful. What does this show?:
>>>
>>> vmstat 1
>>>
>
>
>> same for vmstat 1 while runing the query
>>
>> vmstat 1
>> procs -----------memory---------- ---swap-- -----io---- -system--
>> r b swpd free buff cache si so bi bo in cs
>> 0 0 1280 45752 4496 2963460 0 0 29 45 0 1
>>
>
> Those look like the sort of useless numbers you get on the *first*
> line of vmstat, even with a number. What did a few of the *other*
> lines look like while the query was running?
>
> -Kevin
> .
>
>
They Look exactly the same as the first one, with cache changing form
2963460 to 2961000 so not much difference at all...
So what you say is what I thought, there is something wrong with the OS... we will try to put centos (the same OS as in development) instead of redhat the OS installed by the internet provider and see how it goes. Thanks for your feedback.
Adrien
--
Logo_HBS_mail.jpg
Adrien DUCOS
Analyste développeur
aducos@hbs-research.com <mailto:aducos@hbs-research.com>
www.hbs-research.com <http://www.hbs-research.com/;
+33 (0)9 70 44 64 10
24 rue de l'Est
75020 Paris
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-admin@postgresql.org
Cc: aducos@hbs-research.com, Kevin.Grittner@wicourts.gov
Subject: Re: My server is oddly very slow
In-Reply-To: <4DC3A976.7050707@hbs-research.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