Re: autovacuum, exclude table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Top-posting because this is context free:

You need to provide more info for anybody to help you. Are the tables append-only or are deletes/updates also performed? Also this:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

On Dec 12, 2011 10:26 PM, "Anibal David Acosta" <aa@xxxxxxxxxxxx> wrote:

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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux