On Tue, Nov 10, 2009 at 8:22 AM, Campbell, Lance <lance@xxxxxxxxxxxx> wrote: > Tomorrow I will be migrating from PostgreSQL 8.2 to 8.4. > > In PostgreSQL 8.2 in order for vacuum to work I had to bump up max_fsm_pages > to 1924288. > > 1) In PostgreSQL 8.4 do I need to make any changes to the default settings > for auto vacuum in order for it to run properly? I noticed it does not have > a setting for max_fsm_pages. > > 2) If auto vacuum has issues in 8.4 will PostgreSQL tell me what settings to > tweak like it did in 8.2? The basic gist is that in 8.4 the free space map is dynamic and needs no tweaking. I haven't exercised 8.4 in a busy production environment so I can't say it definitely works, but so far I've seen no reports of it NOT working... -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
