Re: Vacuum analyze vs just Vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum analyze vs just Vacuum
Date
Msg-id 3253.959528722@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum analyze vs just Vacuum  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
"Bryan White" <bryan@arcamax.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

pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Vacuum analyze vs just Vacuum
Next
From: Bruce Momjian
Date:
Subject: Re: Vacuum analyze vs just Vacuum