From: Anibal David Acosta <aa@devshock.com>
To: 'Craig Ringer' <ringerc@ringerc.id.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum, exclude table
Date: Mon, 12 Dec 2011 11:55:00 -0300
Message-ID: <010a01ccb8de$07c0ad20$17420760$@devshock.com> (raw)
In-Reply-To: <CAD2md3EpKvvEwA_+ZggC0iSO5qCNZ3_eZ25N9Gc7cqLkV3FAPg@mail.gmail.com>
References: <00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com>
<CAD2md3EpKvvEwA_+ZggC0iSO5qCNZ3_eZ25N9Gc7cqLkV3FAPg@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: aa@devshock.com, ringerc@ringerc.id.au
Subject: Re: autovacuum, exclude table
In-Reply-To: <010a01ccb8de$07c0ad20$17420760$@devshock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox