Re: Vacuum analyze vs just Vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bryan White" <bryan(at)arcamax(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum analyze vs just Vacuum
Date: 2000-05-28 15:45:22
Message-ID: 3253.959528722@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bryan White" <bryan(at)arcamax(dot)com> writes:
> I would just like to check an assumption. I "vacuum analyze" regularly. I
> have always assumed that this did a plain vacuum in addition to gathering
> statistics. Is this true?

Yes. There are some poorly-worded places in the docs that make it sound
like they might be completely separate operations, but they're not.

I would like to split out ANALYZE as a separately-callable command at
some point, but we'll no doubt continue to offer the combined "vacuum
analyze" command, if only for backward-compatibility reasons...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-05-28 17:58:09 Re: Vacuum analyze vs just Vacuum
Previous Message Bryan White 2000-05-28 15:23:13 Vacuum analyze vs just Vacuum