Postgres Pro
Downloads
Home   >   mailing lists

autovacuum, exclude table - Mailing list pgsql-performance

From Anibal David Acosta
Subject autovacuum, exclude table
Date
Msg-id 00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com
Whole thread Raw
Responses Re: autovacuum, exclude table  (Craig Ringer <ringerc@ringerc.id.au>)
Re: autovacuum, exclude table  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Common slow query reasons - help with a special log
Next
From: Craig Ringer
Date:
Subject: Re: autovacuum, exclude table