Обсуждение: 8.4 auto vacuum

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

On Tue, Nov 10, 2009 at 8:22 AM, Campbell, Lance <lance@illinois.edu> 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...