Skip site navigation (1) Skip section navigation (2)

Re: autovacuum, exclude table

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: "'Craig Ringer'" <ringerc(at)ringerc(dot)id(dot)au>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: autovacuum, exclude table
Date: 2011-12-12 14:55:00
Message-ID: 010a01ccb8de$07c0ad20$17420760$@devshock.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)ringerc(dot)id(dot)au] 
Enviado el: lunes, 12 de diciembre de 2011 11:45 a.m.
Para: Anibal David Acosta
CC: pgsql-performance(at)postgresql(dot)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(at)devshock(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2011-12-12 15:16:08
Subject: Re: autovacuum, exclude table
Previous:From: Craig RingerDate: 2011-12-12 14:45:24
Subject: Re: autovacuum, exclude table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group