autovacuum, exclude table

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: autovacuum, exclude table
Date: 2011-12-12 14:25:43
Message-ID: 00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have a couple of tables with about 400millions of records increasing about
5 millions per day.

I think that disabling autovac over those tables, and enabling daily manual
vacuum (in some idle hour) will be better.

I am right?

Is possible to exclude autovacuum over some tables?

Thanks!

Anibal

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-12-12 14:45:24 Re: autovacuum, exclude table
Previous Message Tomas Vondra 2011-12-11 03:11:22 Re: Common slow query reasons - help with a special log