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.
In response to
pgsql-admin by date
|Next:||From: Jessica Richard||Date: 2008-03-17 15:07:37|
|Subject: invalid memory alloc request |
|Previous:||From: Mark Steben||Date: 2008-03-17 14:31:02|
|Subject: auto_vacuum question|