Re: heavy swapping, not sure why - Mailing list pgsql-general

From Tom Lane
Subject Re: heavy swapping, not sure why
Date
Msg-id 25094.1314731935@sss.pgh.pa.us
Whole thread Raw
In response to Re: heavy swapping, not sure why  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: heavy swapping, not sure why  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> On Tue, Aug 30, 2011 at 11:17 AM, Lonni J Friedman <netllama@gmail.com> wrote:
>> In the past 18 hours, swap usage has nearly doubled on systemA:
>> $ free -m
>>             total       used       free     shared    buffers     cached
>> Mem:         56481      56210        271          0         11      52470
>> -/+ buffers/cache:       3727      52753
>> Swap:         1099         35       1064
>>
>> As a reminder, this is what it was yesterday afternoon (roughly 18
>> hours earlier):
>>            total       used       free     shared    buffers     cached
>> Mem:         56481      55486        995          0         15      53298
>> -/+ buffers/cache:       2172      54309
>> Swap:         1099         18       1081

> This is totally uninteresting.

Yeah.  You're going to need a whole lot more than 17MB of bloat before
it'll be possible to tell which process is at fault, given that the
expected process sizes are up to 10GB.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: IDLE queries taking up space
Next
From: Merlin Moncure
Date:
Subject: Re: pg_upgrade from 8.3.4 issue