Re: autovacuum question

[Carol Walter <walterc(at)indiana(dot)edu>]

Hi, I'm looking in my log file with today's date.  I'm using VIM and  
have done a search for a pattern match on "autovac", "vacuum", and  
"auto"  VIM returned "string not found" for each search.  Am I  
looking for the wrong  string, or is there another log file I should  
be looking at?

Carol
On Mar 30, 2007, at 10:59 AM, Thomas Pundt wrote:

> 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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/  
> ----