Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073