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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-01-28 16:09:25 PG_STAT_DATABASE
Previous Message Didier Gasser-Morlay 2010-01-28 06:46:00 PpgSQL Autovacuum