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

Re: PpgSQL Autovacuum

From: Edi Stojicevic <estojicevic(at)debianworld(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PpgSQL Autovacuum
Date: 2010-01-28 08:51:02
Message-ID: 20100128085102.GA5233@kayo.space.world (view raw or flat)
Thread:
Lists: pgsql-novice
* Didier Gasser-Morlay <didiergm(at)gmail(dot)com> [2010-01-28 07:46:00 +0100] wrote :

> Hello,
> 
> Could someone point me to a good reading on autovacuum; I clearly do not
> understand how to get it to work, as I thought it was 'automatic' (hence the
> name :) but whilst viewing tables with PgAdmin III I get more often than not
> a message indicating that that table were quite a number of data input have
> been made should be vacuumed ... so this does not work as I thought it
> would.
> 
> Any advice ?
> 
> Didier

Hi,

Did you take a look at
http://www.postgresql.org/docs/8.4/interactive/maintenance.html ?

Kind regards,

-- 
 .''`.  Edi Stojicevic
: :'  : Debian GNU/Linux user, admin & developer - http://www.debian.org
`. `~'  French speaking Debian website founder   - http://www.debianworld.org
  `-    GPG Key Id : 0x1237B032

In response to

pgsql-novice by date

Next:From: Mladen GogalaDate: 2010-01-28 16:09:25
Subject: PG_STAT_DATABASE
Previous:From: Didier Gasser-MorlayDate: 2010-01-28 06:46:00
Subject: PpgSQL Autovacuum

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