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 Armbrust||Date: 2008-04-30 16:17:23|
|Subject: Re: Deadlock situation?|
|Previous:||From: Scott Marlowe||Date: 2008-04-30 15:52:39|
|Subject: Re: Quoting "|