| From: | Adam Kavan <akavan(at)cox(dot)net> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_autovacuum |
| Date: | 2003-09-03 00:40:17 |
| Message-ID: | 5.2.1.1.0.20030902193736.00a4f860@pop.central.cox.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>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
--- akavan(at)cox(dot)net
| Attachment | Content-Type | Size |
|---|---|---|
| pg_autovacuum.out.bz2 | application/octet-stream | 9.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-09-03 01:23:17 | Debian Woody 7.3.4 packages? |
| Previous Message | Matthew T. O'Connor | 2003-09-03 00:31:51 | Re: pg_autovacuum |