| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Carol Walter <walterc(at)indiana(dot)edu> |
| Cc: | Robert Treat <robert(at)omniti(dot)com>, pgsql-admin(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Auto vacuum |
| Date: | 2007-04-19 14:53:20 |
| Message-ID: | 20070419145320.GD8402@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander | 2007-04-19 14:59:34 | PGcluster replicator from_host:0.0.0.0 |
| Previous Message | Jaume Sabater | 2007-04-19 09:56:46 | pg_dump and pg_restore with different owners |