Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Date
Msg-id 20070508215213.GC24167@alvh.no-ip.org
Whole thread Raw
In response to What's The Difference Between VACUUM and VACUUM ANALYZE?  ("Y Sidhu" <ysidhu@gmail.com>)
Responses Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
List pgsql-performance
Tree view 
Y Sidhu escribió:
> 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.

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

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?