| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUM FULL cannot be VERBOSE? |
| Date: | 2011-06-30 18:21:10 |
| Message-ID: | BANLkTi=bAf3xk_uc-L67sJa5tFM3EK0wdg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2011/6/30 Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>:
> is it correct behavior that when i issue command "VACUUM VERBOSE", i get
> output with DETAIL info, but when i issue "VACUUM FULL VERBOSE", no
> details are displayed?
Yes, this seems OK. PostgreSQL 9.0 has a new implementation of VACUUM
FULL, which behaves more like CLUSTER. This new implementation doesn't
account statistics like a normal VACUUM VERBOSE does.
It seems that PostgreSQL 9.1 re-adds these stats to VACUUM FULL VERBOSE.
Regards,
Marti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Koterov | 2011-06-30 18:40:39 | How to create "auto-increment" field WITHOUT a sequence object? |
| Previous Message | Dmitry Koterov | 2011-06-30 18:20:45 | How to create "auto-increment" field WITHOUT a sequence object? |