By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,549 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,549 IT Pros & Developers. It's quick & easy.

Does "vacuum analyze" contain "vacuum"?

P: n/a
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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
<ho****@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

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

Nov 11 '05 #2

P: n/a
On Sun, 7 Sep 2003, Manfred Koizar wrote:
On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen
<ho****@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/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

Nov 11 '05 #3

P: n/a
Holger Marzen writes:
I am not sure if "vacuum analyze" contains a "vacuum".


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

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #4

P: n/a
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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #5

P: n/a
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.

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

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

Nov 11 '05 #6

P: n/a
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
<an****@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.