On Thu, Oct 21, 2010 at 3:14 PM, Nick <t32@2thebatcave.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.