Nick <[email protected]> wrote: > Here is a vmstat 1 right after postgres has been started: > > procs -----------memory---------- > r b swpd free buff cache > 0 0 55480 760172 1709424 3758492 > Here is another chunk after it's been running for about 18 hours: > > procs -----------memory---------- > r b swpd free buff cache > 0 0 1812168 20332 59452 102172 > Here is a snapshot of all the postgres processes as listed in top > (29582 = postgres: autovacuum launcher process): > > 29582 pgsql 15 0 8739m 6.7g 1816 S 8.9 86.1 91:10.44 > postgres Ouch! I've not seen anything remotely like that. I wonder what's different.... > As you can see, after a while the system is using a lot of swap. > The first time I noticed the problem, the swap was up to 12G > (there is 8GB of ram in this system). I believe postgres was > running for several days to achieve that much memory utilization. Is there anything unusual in the logs? -Kevin
-- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
