Re: autovacuum launcher process eating up 17G+ of ram? - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: autovacuum launcher process eating up 17G+ of ram?
Date
Msg-id 4CC578BF0200002500036DC0@gw.wicourts.gov
Whole thread Raw
In response to Re: autovacuum launcher process eating up 17G+ of ram?  (Nick <t32@2thebatcave.com>)
List pgsql-admin
Nick <t32@2thebatcave.com> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>
>> I've not seen anything remotely like that.  I wonder what's
>> different....
>
> I did a test with the same postgres build (and autovacuum_naptime
> = 1 as well) on the same OS with only the system databases
> (postgres, template0, template1), and after the weekend the memory
> utilization was acceptable:

That's probably it.  Our shop normally has just one application
database in a cluster, and I can't think of any clusters with more
than three or four.  It sounds like there might be some sort of
memory leak when a vacuum worker switches databases.

-Kevin

pgsql-admin by date:

Previous
From: Nick
Date:
Subject: Re: autovacuum launcher process eating up 17G+ of ram?
Next
From: Tom Lane
Date:
Subject: Re: autovacuum launcher process eating up 17G+ of ram?