Re: auto_vacuum question

Mark Steben wrote:
> We upgraded from postgres 7.4.5 to 8.2.5 a couple weekends ago.  I just
> turned auto vacuum on today.
>
> I manually inserted 4 entries in PG_AUTOVACUUM with enabled = 'f' to exclude
> these larger tables
> That we manually vacuum every night.  But the first tables that autovacuum
> chooses to vacuum are
>
> These 4 tables.  Am I missing something?

My guess is that you set the rest of the settings to 0, particularly for
the freeze settings.  In that case, try changing them to -1.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.