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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
