Обсуждение: 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?