Re: vacuuming not working?

"David Esposito" <dvesposito@newnetco.com> writes:
> i took a peek at pg_stat_activity and it doesn't appear as though any of the
> processes are doing anything ... they all have blanks for "current_query"

Read
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring-stats.html

> Is there any way to get timestamps turned on in the log file?

There's a flag in postgresql.conf.  You might wanna turn on log_pid too.

            regards, tom lane