Matthew T. O'Connor wrote:
> 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