Good ideas except I think I wasn't clear. The system is a commercial product
with numerous individual customers. Each customer is somewhat unique and we
want to have the system capable of vacuuming automatically for all users.
The thing is that some users might have systems that are used little in the
early morning but others might be very different. We would rather not do
usage statistic gathering/analysis if there was a better way.
-Rainer
> -----Original Message-----
> From: pgsql-admin-owner@hub.org
> [mailto:pgsql-admin-owner@hub.org]On Behalf Of Neil Toronto
> Sent: Friday, July 14, 2000 8:48 AM
> To: pgsql-admin@postgresql.org
> Subject: RE: [ADMIN] vacuum
>
>
> Maybe a good measure of how often the database needs to be vacuumed is how
> often the administrators currently vacuum it?
>
> For instance, if it's being vacuumed less than once a day, it may be
> perfectly acceptable to vacuum it once early in the morning when nobody is
> using it - assuming nobody uses it then, of course.
>
> If the administrators have been using the product for a while, it
> may not be
> too much of a problem to ask when the "slow times" are - you might be able
> to just ask them. We do electronic billing, and I've found that
> the people
> who know the most about slow times and such are those people, and the Tech
> Support Queen.
>
> Just a couple of thoughts...
> Neil