Re: Is VACUUM ANALYZE a superset of VACUUM?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dustin Sallings <dustin(at)spy(dot)net>
Cc: Forest Wilkinson <fspam(at)home(dot)com>, pgsql-general(at)hub(dot)org
Subject: Re: Is VACUUM ANALYZE a superset of VACUUM?
Date: 2000-10-14 04:53:09
Message-ID: 1748.971499189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dustin Sallings <dustin(at)spy(dot)net> writes:
> I'm quite sure ``vacuum analyze'' does both.

Correct.

> Is there a reason there's no ``analyze?''

Historical, mostly. No essential reason I can think of. In current
sources the "analyze" part is run as a separate read-only transaction
after the data-compaction "vacuum" part, so they're at arm's length
already. But no one's got round to building a separate statement.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-14 05:40:30 Re: Matlab Mex Interface
Previous Message Tom Lane 2000-10-14 04:42:03 Re: config