From: Rainer Mager <rmager@vgkk.com>
To: pgsql-admin@postgresql.org
Subject: RE: vacuum
Date: Fri, 14 Jul 2000 10:55:07 +0900
Message-ID: <NEBBJBCAFMMNIHGDLFKGOELPCDAA.rmager@vgkk.com> (raw)
In-Reply-To: <14A4DCD7F3CED3118749009027DCBFE4A2C3F0@smtp.stsrvcs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rmager@vgkk.com
Subject: RE: vacuum
In-Reply-To: <NEBBJBCAFMMNIHGDLFKGOELPCDAA.rmager@vgkk.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox