First, I meant to ask for debug level 3, (-d3, not -d2) sorry.... Also, are you sure that pg_autovacuum is connecting to the same database cluster as your insert delete script?
I have attached a new log with a debug level of 3. And I am sure they are connecting to the same cluster, I only have one postgres box that is active.
In the output you should see the cur_analyze_count increase with each insert and the curr_delete_count increase with every delete. Also, the debug output should tell you the threshold you have to reach for a vacuum or analyze.
And there is the problem, all of the counts stay at 0 no matter what I do.
--- Adam Kavan
--- [EMAIL PROTECTED]
pg_autovacuum.out.bz2
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match