Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Tue, Aug 30, 2011 at 11:17 AM, Lonni J Friedman <netllama@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general