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 <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly