Skip site navigation (1) Skip section navigation (2)

Re: Why is postgres autovacuuming a table that is neverupdated?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Joseph S <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why is postgres autovacuuming a table that is neverupdated?
Date: 2008-04-30 16:13:15
Message-ID: 20080430161315.GB21286@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Dan ArmbrustDate: 2008-04-30 16:17:23
Subject: Re: Deadlock situation?
Previous:From: Scott MarloweDate: 2008-04-30 15:52:39
Subject: Re: Quoting "

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group