Re: autovacuum questions - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: autovacuum questions
Date
Msg-id 20081031160213.GC10668@alvh.no-ip.org
Whole thread Raw
In response to Re: autovacuum questions  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
Responses Re: autovacuum questions  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
Rafael Domiciano escribió:

> The vacuum is not full, to run a full vacuum you need to set a cron job;
> better to run at the night.

Doing VACUUM FULL on crontab is rarely a good idea.  If you find
yourself in a situation where you need VACUUM FULL, then you've not
tuned regular vacuum appropriately.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: "Rafael Domiciano"
Date:
Subject: Re: autovacuum questions
Next
From: "Scott Marlowe"
Date:
Subject: Re: autovacuum questions