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

From: Joseph S <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why is postgres autovacuuming a table that is never updated?
Date: 2008-04-30 15:52:09
Message-ID: fva4j8$2sga$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-04-30 15:52:39 Re: Quoting "
Previous Message Tom Lane 2008-04-30 15:33:35 Re: Deadlock situation?