Home > mailing lists

autovacuum, exclude table - Mailing list pgsql-performance

From	Anibal David Acosta
Subject	autovacuum, exclude table
Date	December 12, 2011 10:26:03
Msg-id	00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com Whole thread Raw
Responses	Re: autovacuum, exclude table Re: autovacuum, exclude table
List	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

From: Tomas Vondra
Date: 10 December 2011, 23:11:41
Subject: Re: Common slow query reasons - help with a special log

From: Craig Ringer
Date: 12 December 2011, 10:45:45
Subject: Re: autovacuum, exclude table