473,320 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

Nov 11 '05 #1
6 3447
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Greg Stark | last post by:
This query is odd, it seems to be taking over a second according to my log_duration logs and according to psql's \timing numbers. However explain analyze says it's running in about a third of a...
5
by: jensen bredal | last post by:
I need to keep track on user "session data" while still turning session off as i do not want users login to expire? Thanks JB
4
by: Joe Lester | last post by:
I'm trying to figure out what the optimal Postgres configuration would be for my server (with 200 connecting clients, even though I'd really like to get it up to 500). I've got a 700 MHz eMac...
1
by: Mike Hunter | last post by:
(Please CC me on any replies as I'm not on the list) Hi, After a recent power failure, a program that uses a pgsql backend (netdisco) started to send me nastygrams. I tried the author's...
0
by: Felix Finch | last post by:
I have a perl test program which has about 80 test cases, each of which creates its own schema so I can remove them with DROP SCHEMA xxx CASCADE. Normally each test case creates and drops the same...
2
by: borajetta | last post by:
ERROR: duplicate key violates unique constraint "pg_class_oid_index" I found a post earlier but wanted to post up my info as the other persons did not look like the same type of error: I tried...
49
by: matty | last post by:
Hi, I recently got very confused (well that's my life) about the "undefined" value. I looked in the FAQ and didn't see anything about it. On...
42
by: Sabiyur | last post by:
Hi all, one of the recent post gives the macro to do swap #define SWAP(m, n) (tmp = (m), (m) = (n), (n) = tmp) This macro will work, if the execution is from left to right. That is step 1)...
24
by: Jeremy J Starcher | last post by:
While reading c.l.j, I've noticed that some people prefer and indeed even recommend the use of "window.alert()" over "alert()". I can't find any technical reason to make this distinction, and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.