Обсуждение: PpgSQL Autovacuum
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
* 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
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