Обсуждение: best way to run vacuum

Hey guys,

What's the best way to have vacuum run periodically?  I noticed there is also a utility called vacuumdb, can someone
suggestthe best way to call this on a daily basis?  Right now we use a program called crodsys to run any scripts on a
dailybasis, but the company that makes it has recently dropped support for it. 

Roy.

Roy,

On Thu, Sep 20, 2001 at 04:53:44PM -0400, roypgsqlcygwin@xemaps.com wrote:
> What's the best way to have vacuum run periodically?  I noticed there is
> also a utility called vacuumdb, can someone suggest the best way to call
> this on a daily basis?  Right now we use a program called crodsys to run
> any scripts on a daily basis, but the company that makes it has recently
> dropped support for it.

Why not use cron?  That is what one would do on Unix.

Jason

But I'm on NT/2000, there is no cron available.  Or does cygwin come with a way of setting up a cron service?

Roy.

> Roy,
>
> On Thu, Sep 20, 2001 at 04:53:44PM -0400,
> roypgsqlcygwin@xemaps.com wrote:
> > What's the best way to have vacuum run periodically?
>
> Why not use cron?  That is what one would do on Unix.
>
> Jason
>

Roy,

On Fri, Sep 21, 2001 at 11:23:17AM -0400, roypgsqlcygwin@xemaps.com wrote:
> But I'm on NT/2000, there is no cron available.  Or does cygwin come with
> a way of setting up a cron service?

Yes, see the following:

    http://www.cygwin.com/ml/cygwin-announce/2001/msg00117.html

Jason

Whoops!  Forgot to read the README at /usr/doc/cygwin/cron.README

sorry guys and thanx jason.

Roy.