Does "vacuum analyze" contain "vacuum"?

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/pk...rch=0xB5A1AFE1

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

re: Does "vacuum analyze" contain "vacuum"?

On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
<holger@marzen.de> wrote:[color=blue]
>[...] (in version 7.1.x, 7.2.x) [...] is a
>
>vacuum analyze
>
>enough?[/color]

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

Servus
Manfred

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: Does "vacuum analyze" contain "vacuum"?

On Sun, 7 Sep 2003, Manfred Koizar wrote:
[color=blue]
> On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
> <holger@marzen.de> wrote:[color=green]
> >[...] (in version 7.1.x, 7.2.x) [...] is a
> >
> >vacuum analyze
> >
> >enough?[/color]
>
> As far as I remember, yes.
> BTW, what keeps you from upgrading to 7.3.4?[/color]

Never change a running system.

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pk...rch=0xB5A1AFE1

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

re: Does "vacuum analyze" contain "vacuum"?

Holger Marzen writes:
[color=blue]
> I am not sure if "vacuum analyze" contains a "vacuum".[/color]

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

--
Peter Eisentraut peter_e@gmx.net


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

re: Does "vacuum analyze" contain "vacuum"?

On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:[color=blue]
> 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[/color]

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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

re: Does "vacuum analyze" contain "vacuum"?

On 8 Sep 2003, Matthew T. O'Connor wrote:
[color=blue]
> On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:[color=green]
> > 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[/color]
>
> vacuum analyze = vacuum + analyze
>
> FYI, I don't remember it if was added in 7.2, or 7.3, but you can now
> do:[/color]

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.



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

re: Does "vacuum analyze" contain "vacuum"?

On Sun, Sep 07, 2003 at 09:24:36PM +0200, Holger Marzen wrote:[color=blue]
>
> Never change a running system.[/color]

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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org