Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL cannot be VERBOSE? - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: VACUUM FULL cannot be VERBOSE?
Date
Msg-id BANLkTi=bAf3xk_uc-L67sJa5tFM3EK0wdg@mail.gmail.com
Whole thread Raw
In response to VACUUM FULL cannot be VERBOSE?  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-general
Tree view 
2011/6/30 Miroslav Šulc <miroslav.sulc@startnet.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Contrib source
Next
From: Dmitry Koterov
Date:
Subject: How to create "auto-increment" field WITHOUT a sequence object?