My pg_catalog.pg_autovacuum table contains no entries.
Carol Walter
On Apr 19, 2007, at 10:53 AM, Alvaro Herrera wrote:
Carol Walter wrote:
Robert,
I did as you suggested and the values for autovacuum are null,
therefore I'm guessing it isn't running. Since postgres reports
that
it is running, what other things might keep in from running?
Too high thresholds? All tables disabled in pg_autovacuum?
naptime set
too high?
I suggest you turn log_min_messages more verbose, to DEBUG2, and
see if
there are any entries in there regarding autovacuum. If it's
running,
you would see it. You would get a message after autovacuum_naptime
seconds.
How long is autovacuum_naptime anyway?
--
Alvaro Herrera http://
www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
