Skip site navigation (1) Skip section navigation (2)

Re: autovacuum launcher process eating up 17G+ of ram?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Nick <t32(at)2thebatcave(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
Date: 2010-10-22 02:22:16
Message-ID: AANLkTimRUjJta-3kyyXWg2FiFcza1f2RdwWu6hF4ciye@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Oct 21, 2010 at 3:14 PM, Nick <t32(at)2thebatcave(dot)com> wrote:
> I have a production server running postgres 8.3.11.  I did a dump all
> and loaded up postgres 9.0.1 on another server.  On the new server,
> the postgres autovacuum launcher process eats up an insane amount of
> ram (I have seen 17G virt with 6.5G res).  On the older version, it's
> at a reasonable 9MB res after running for a month straight.

What's you're shared_buffers set to?

What does VIRT, RES and SHR?  Is SHR really big?  If RES is close to
SHR, then don't worry too much.

In response to

pgsql-admin by date

Next:From: NickDate: 2010-10-22 17:28:03
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
Previous:From: Kevin GrittnerDate: 2010-10-21 21:59:19
Subject: Re: autovacuum launcher process eating up 17G+ of ram?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group