On Thu, Oct 21, 2010 at 3:14 PM, Nick <t32@xxxxxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
