Does "vacuum analyze" contain "vacuum"?

On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
<holger@marzen.de> wrote:

[...] (in version 7.1.x, 7.2.x) [...] is a

vacuum analyze

enough?

As far as I remember, yes.
BTW, what keeps you from upgrading to 7.3.4?

Servus
Manfred

On Sun, 7 Sep 2003, Manfred Koizar wrote:

On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
<holger@marzen.de> wrote:

[...] (in version 7.1.x, 7.2.x) [...] is a

vacuum analyze

enough?

As far as I remember, yes.
BTW, what keeps you from upgrading to 7.3.4?

Never change a running system.

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&amp;search=0xB5A1AFE1

Holger Marzen writes:

I am not sure if "vacuum analyze" contains a "vacuum".

"vacuum analyze" = "vacuum" + "analyze"

--
Peter Eisentraut peter_e@gmx.net

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.

On 8 Sep 2003, Matthew T. O'Connor wrote:

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:

7.2 for sure had analyze. I'm still using it in production (although it
is getting a bit long in the tooth nowadays)

Looking at the docs for 7.1, it didn't.

On Sun, Sep 07, 2003 at 09:24:36PM +0200, Holger Marzen wrote:

Never change a running system.

Well, unless the running system has known bugs. Which 7.1 and 7.2
both assuredly do.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110