Thread: VACUUM VERBOSE ANALYZE does not work on 7.4.1
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.
Joseph Shraibman <jks@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
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
pgman@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
Joseph Shraibman wrote: > 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? Nothing I can think of, and no one has reported any similar problems. -- Bruce Momjian | http://candle.pha.pa.us pgman@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
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?