Re: Running vacuum on cron
Fran Fabrizio <ffabrizio@mmrd.com>
From: Fran Fabrizio <ffabrizio@mmrd.com>
To: Pedro Alves <pmalves@think.co.pt>
Cc: PostGreSQL <pgsql-general@postgresql.org>
Date: 2001-10-29T17:49:50Z
Lists: pgsql-general
Pedro Alves wrote: > Hi. Is there any way to put a vacuum and a vacuum analyze (the > second does everything the first does? Or do I need to use both?) in a cron > so that it is executed nightly? Sorry to double, but the -z flag on vacuumdb will also do the analyze for you, so you can do it all in one command. -Fran