Обсуждение: PpgSQL Autovacuum

Поиск
Список
Период
Сортировка

PpgSQL Autovacuum

От
Didier Gasser-Morlay
Дата:
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

Re: PpgSQL Autovacuum

От
Edi Stojicevic
Дата:
* Didier Gasser-Morlay <didiergm@gmail.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

Re: PpgSQL Autovacuum

От
Didier Gasser-Morlay
Дата:
 Edi 

reading this lead me to realise that I always had wrong assumptions on how postgreSQL.conf works: when autovacuum = on is commented in a standard .conf file, it does not mean this is the default value; uncommented it and everything now works fine;

thanks 
Didier