adrien ducos <aducos(at)hbs-research(dot)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