Postgres Pro
Downloads
Home   >   mailing lists

Re: calling vacuum from a script - Mailing list pgsql-general

From Devrim GÜNDÜZ
Subject Re: calling vacuum from a script
Date
Msg-id 1277268783.27782.0.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to calling vacuum from a script  (Janet Jacobsen <jsjacobsen@lbl.gov>)
Responses Re: calling vacuum from a script
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: David Dick
Date:
Subject: Re: calling vacuum from a script
Next
From: John R Pierce
Date:
Subject: Re: calling vacuum from a script