Re: Does "vacuum analyze" contain "vacuum"?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: holger(at)marzen(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does "vacuum analyze" contain "vacuum"?
Date: 2003-09-08 16:24:31
Message-ID: 1063038270.6118.1.camel@zeutrh9
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:
> Hi all,
>
> the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to
> help the analyzer AND free unused space do I have to do a
>
> vacuum
> vacuum analyze
>
> or is a
>
> vacuum analyze

vacuum analyze = vacuum + analyze

FYI, I don't remember it if was added in 7.2, or 7.3, but you can now
do:

vacuum = just vacuum
vacuum analyze = vacuum + analyze
analyze = just analyze

analyze is all you need if you want to update planner statistics without
trying to reclaim any space.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-09-08 16:32:45 Re: decrypted pwd
Previous Message scott.marlowe 2003-09-08 16:14:47 Re: decrypted pwd