Re: autovacuum question - Mailing list pgsql-admin

From Thomas Pundt
Subject Re: autovacuum question
Date
Msg-id 200703301659.41322.mlists@rp-online.de
Whole thread Raw
In response to autovacuum question  (Carol Walter <walterc@indiana.edu>)
Responses Re: autovacuum question
List pgsql-admin
Hi,

On Friday 30 March 2007 16:43, Carol Walter wrote:
| I ran the command "show autovacuum" and postgres responds with "ON."
| My colleague says that I should be able to see it running if I run ps
| -aef.  He said that he doesn't trust postgres reporting on itself.
| When I run the Unix ps command as above I don't see autovacuum.  Does
| anyone know if it's running or not?  This is on a box running Solaris.

you will only see it if it is currently processing your databases. Look
at the PostgreSQL log file, if it has entries from autovacuum.

Ciao,
Thomas

--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: autovacuum question
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum question