Re: calling vacuum from a script

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Janet Jacobsen <jsjacobsen(at)lbl(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: calling vacuum from a script
Date: 2010-06-23 04:53:03
Message-ID: 1277268783.27782.0.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2010-06-22 at 20:44 -0700, Janet Jacobsen wrote:
> Is it possible to vacuum a table (vacuum full analyze)
> from a script.

Use vacuumdb command.

(Why are you using VACUUM FULL? It has been considered harmful, at least
for a regular maintenance job.)
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-06-23 05:38:27 Re: calling vacuum from a script
Previous Message David Dick 2010-06-23 04:06:23 Re: calling vacuum from a script