On Friday 25 April 2003 21:13, Dennis Gearon wrote:
> You know,
> It'd be nice if there was a system table, or command that showed the
> number and/or percentage of tuples needing to be vacuumed. If table are
> only affected by tuples formerly in them, then the table/function could
> show the value per table. If any discarded tuples affect all tables, then a
> global table/function would be warranted.
>
> A minimally compute intensive chron job or ON DELETE trigger could then
> call vacuum full at a certain percentage. Also, what kind of memory
> management ( in the postgres application ) could be written that pushes
> deleted/unused tuples out of any caches or scopes to at least lengthen the
> time between vacuums?
Why don't you take a look at pgavd? It will periodically connect to database
and check if it needs vacuum. just that it won't issue vacuum full because it
locks table and IMO only administrator should do it.
http://gborg.postgresql.org/project/pgavd/projdisplay.php
Shridhar
