Thread: Does "vacuum analyze" contain "vacuum"?

Does "vacuum analyze" contain "vacuum"?

From
Holger Marzen
Date:
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

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

Regards
Holger

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

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

From
Manfred Koizar
Date:
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

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

From
Holger Marzen
Date:
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&search=0xB5A1AFE1

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

From
Peter Eisentraut
Date:
Holger Marzen writes:

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

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

--
Peter Eisentraut   peter_e@gmx.net


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

From
"Matthew T. O'Connor"
Date:
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.


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

From
"scott.marlowe"
Date:
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.



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

From
Andrew Sullivan
Date:
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