Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeder.erje.net!newsfeed.utanet.at!newscore.univie.ac.at!aconews-feed.univie.ac.at!aconews.univie.ac.at!not-for-mail From: "Laurenz Albe" Newsgroups: comp.databases.postgresql References: <1cd5172d-eab8-45e9-b9a0-4bd6744819ed@cu4g2000vbb.googlegroups.com> Subject: Re: Vaccum Date: Fri, 6 May 2011 16:39:04 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090 Organization: dienste.wien.at ISP Message-ID: <1304692765.340927@proxy.dienste.wien.at> X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) Lines: 16 NNTP-Posting-Host: 141.203.254.23 X-Trace: 1304692766 aconews.univie.ac.at 73248 141.203.254.23 X-Complaints-To: abuse@univie.ac.at Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:118 Pedro Henrique wrote: > Good Morning, How do I run the windows Vacuum every day in a given > schedule You can create a vacuumdb job with the job scheduler. On Windows XP the job scheduler is found in Start > Programs > Accessories > System Tools > Scheduled Tasks Did you consider autovacuum? It is recommended and turned on by default in recent PostgreSQL versions. Yours, Laurenz Albe