Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 30 Apr 2008 11:52:09 -0400
- Message-id: <fva4j8$2sga$1(at)news(dot)hub(dot)org>
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 thinkyou 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.
- Follow-Ups:
- Re: Why is postgres autovacuuming a table that is never updated?
- From: Alvaro Herrera
- Re: Why is postgres autovacuuming a table that is never updated?
- References:
- Why is postgres autovacuuming a table that is never updated?
- From: Joseph S
- Re: Why is postgres autovacuuming a table that is never updated?
- From: Andrew Sullivan
- Why is postgres autovacuuming a table that is never updated?
- Prev by Date: Re: Quoting "
- Next by Date: Re: Why is postgres autovacuuming a table that is never updated?
- Previous by thread: Re: Why is postgres autovacuuming a table that is never updated?
- Next by thread: Re: Why is postgres autovacuuming a table that is never updated?
- Indexes: