Re: What's The Difference Between VACUUM and VACUUM ANALYZE? - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Date
Msg-id 20070508220608.GA8457@uio.no
Whole thread Raw
In response to Re: What's The Difference Between VACUUM and VACUUM ANALYZE?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
List pgsql-performance
On Tue, May 08, 2007 at 05:52:13PM -0400, Alvaro Herrera wrote:
>> I am trying to follow a message thread. One guy says we should be running
>> vacuum analyze daily and the other says we should be running vacuum multiple
>> times a day. I have tried looking for what a vacuum analyze is to help me
>> understand but no luck.
> VACUUM ANALYZE is like VACUUM, except that it also runs an ANALYZE
> afterwards.

Shoot me if I'm wrong here, but doesn't VACUUM ANALYZE check _all_ tuples,
as compared to the random selection employed by ANALYZE?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Next
From: Alvaro Herrera
Date:
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?