Could you please explain this better, I don't really understand what the problem is. If you want pg_autovacuum to perform a vacuum on a table that has had exactly X updates no matter what, you can just run it with -V0 -vX (where X is the vacuum threshold) same thing can be done for analyze. Are you saying that you did this and it did not work as expected?
I think the problem with that (I initially tried it myself) is that without a per-table setting, it is impractical. For instance, I want the one large table in my app vacuumed every 500,000 dead tuples, but now my smaller tables never reach the threshold.
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
