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? Thanks, Lance Campbell Project Manager/Software Architect/DBA Web Services at Public Affairs 217-333-0382
