From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1 |
Date: | 2004-01-07 20:18:55 |
Message-ID: | 200401072018.i07KIuK16970@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2004-01-07 20:26:36 | Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1 |
Previous Message | Tom Lane | 2004-01-07 20:04:59 | Re: VACUUM VERBOSE ANALYZE does not work on 7.4.1 |