The postgres version is 9.0.4 on a Windows Server 2008 (planning to upgrade to 9.1)
Tables has insert (in bulk every 3 minutes) and delete one per day (delete records older than XX days)
There are not much additional relevant information.
Thanks!
De: Craig Ringer [mailto:ringerc@ringerc.id.au]
Enviado el: lunes, 12 de diciembre de 2011 11:45 a.m.
Para: Anibal David Acosta
CC: pgsql-performance@postgresql.org
Asunto: Re: [PERFORM] autovacuum, exclude table
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@devshock.com> 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
