Re: Why is postgres autovacuuming a table that is never updated?

Joseph S wrote:
> Andrew Sullivan wrote:
>
>>
>>> 2) How can I use pg_autovacuum table to disable autovac for this
>>> table? The docs are not clear on how to do this.
>>
>> I think that would be a bad idea, given that autovacuum seems to think
>> you need to do it.
>
> I don't want to totally disable it, but I want to change the numbers so
> it happens less frequently. Since there are no updates I can set
> freeze_min_page to be small and the max between transactions big to keep
> the autovacuum from happening so often.

Agreed, that's a good strategy. You only need to keep an eye on how
often is pg_clog going to be trimmed. (The only disadvantage is how
much spaces it occupies on disk.)

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support