What's The Difference Between VACUUM and VACUUM ANALYZE?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: What's The Difference Between VACUUM and VACUUM ANALYZE?
From: "Y Sidhu" <ysidhu@xxxxxxxxx>
Date: Tue, 8 May 2007 14:43:00 -0700

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.

--
Yudhvir Singh Sidhu
408 375 3134 cell

Follow-Ups:
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  - From: Alvaro Herrera
- Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
  - From: david

Prev by Date: Re: Throttling PostgreSQL's CPU usage
Next by Date: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Previous by thread: Throttling PostgreSQL's CPU usage
Next by thread: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux