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

VACUUM VERBOSE ANALYZE does not work on 7.4.1

P: n/a
Trying this:

VACUUM VERBOSE ANALYZE;

on a 7.4.1 database only does a vacuum, not the analyze. I've tried
this on two seperate databases. Is this a known bug? I haven't seen
anything about it.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Joseph Shraibman <jk*@selectacast.net> writes:
Trying this:
VACUUM VERBOSE ANALYZE;
on a 7.4.1 database only does a vacuum, not the analyze.


Works for me. What's your basis for saying it doesn't analyze?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

P: n/a
Joseph Shraibman wrote:
Trying this:

VACUUM VERBOSE ANALYZE;

on a 7.4.1 database only does a vacuum, not the analyze. I've tried
this on two seperate databases. Is this a known bug? I haven't seen
anything about it.


I just tried it in CVS head and saw:

There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
--> INFO: analyzing "public.g1"
INFO: "g1": 0 pages, 0 rows sampled, 0 estimated total rows
INFO: vacuuming "public.g2"
INFO: "g2": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL: 0 dead row versions cannot be removed yet.

Don't you see that line in your setup?

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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

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

Nov 12 '05 #3

P: n/a
Bruce Momjian wrote:
Joseph Shraibman wrote:
Trying this:

VACUUM VERBOSE ANALYZE;

on a 7.4.1 database only does a vacuum, not the analyze. I've tried
this on two seperate databases. Is this a known bug? I haven't seen
anything about it.

I just tried it in CVS head and saw:

There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
--> INFO: analyzing "public.g1"
INFO: "g1": 0 pages, 0 rows sampled, 0 estimated total rows
INFO: vacuuming "public.g2"
INFO: "g2": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL: 0 dead row versions cannot be removed yet.

Don't you see that line in your setup?

I do now, but wasn't before. Could there be something that makes it
work after I've already done an ANALYSE?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.