Why autovacuum in not running

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Why autovacuum in not running
Date: 2007-12-06 18:50:53
Message-ID: fj9glc$2o1h$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I installed postgres using windows installer and added the following lines
to end of postgresql.conf :

listen_addresses = '*'
log_destination = 'stderr'
redirect_stderr = on
stats_start_collector = on
stats_row_level = on
autovacuum = on
shared_buffers= 15000 #
log_line_prefix='\n%t %u %d %h %p %i %l %x '
log_min_duration_statement = 20000
log_min_messages = warning

I re-loaded configuration. Log file complains that share_buffers setting is
ignored.

So i assume that autovacuum is running.
However log files do not contain any lines about vacuuming.
After running analyze manually query runs a lot faster.
So I think that autovacuum is not runnning in server.
Why ?
How to make it to run ?
How to check is autovacuum running or not ?

Andrus.

"PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2007-12-06 18:52:30 Re: reformatting floats ?
Previous Message Andreas Kretschmer 2007-12-06 18:45:44 Re: reformatting floats ?