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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Daniel Staal
Sent: Wednesday, October 26, 2005 9:00 PM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] vacuuming and manu updates
--As of Wednesday, October 26, 2005 8:57 AM -0700,
operationsengineer1@yahoo.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