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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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