Re: vacuuming and manu updates

From: "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com>
To: "'Daniel Staal'" <DStaal(at)usa(dot)net>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: vacuuming and manu updates
Date: 2005-10-27 09:43:10
Message-ID: 20051027094310.DD546DB09E@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

One option for automating your vacuum process 'a la cron' is to write a
batch file and then run it via the task scheduler at the desired interval.
You can find the task scheduler under: Start -> All Programs -> Accessories
-> System Tools -> Scheduled Tasks

HTH,

Kevin

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Daniel Staal
Sent: Wednesday, October 26, 2005 9:00 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] vacuuming and manu updates

--As of Wednesday, October 26, 2005 8:57 AM -0700,
operationsengineer1(at)yahoo(dot)com is alleged to have said:

> is there a way to automate the vacuum process on
> windows (think cron on linux)?

--As for the rest, it is mine.

I'm sure there is, but I haven't had to touch a Windows computer in a
couple of years...

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Neil Saunders 2005-10-27 13:01:48 Re: Database design advice
Previous Message Michael Fuhr 2005-10-27 06:04:40 Re: Who is logged in?