Re: What's The Difference Between VACUUM and VACUUM ANALYZE?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Y Sidhu <ysidhu(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Date: 2007-05-08 21:52:13
Message-ID: 20070508215213.GC24167@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2007-05-08 22:06:08 Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Previous Message david 2007-05-08 21:46:36 Re: What's The Difference Between VACUUM and VACUUM ANALYZE?