Re: auto_vacuum question - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: auto_vacuum question
Date
Msg-id 20080317145734.GE4317@alvh.no-ip.org
Whole thread Raw
In response to auto_vacuum question  ("Mark Steben" <msteben@autorevenue.com>)
Responses Re: auto_vacuum question  ("Mark Steben" <msteben@autorevenue.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Mark Steben"
Date:
Subject: auto_vacuum question
Next
From: Tom Lane
Date:
Subject: Re: pgAdmin Crashes After Changing Timezone Setting