VACUUM FULL cannot be VERBOSE?

From: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM FULL cannot be VERBOSE?
Date: 2011-06-30 14:18:14
Message-ID: 4E0C85A6.1030102@startnet.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

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?

here are some samples:

VACUUM VERBOSE;
INFO: vacuuming "pg_catalog.pg_type"
INFO: scanned index "pg_type_oid_index" to remove 540 row versions
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: scanned index "pg_type_typname_nsp_index" to remove 540 row versions
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "pg_type": removed 540 row versions in 3 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: index "pg_type_oid_index" now contains 880 row versions in 6 pages
DETAIL: 540 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.

VACUUM FULL VERBOSE;
INFO: vacuuming "pg_catalog.pg_type"
INFO: vacuuming "pg_catalog.pg_attribute"
INFO: vacuuming "pg_catalog.pg_statistic"
INFO: vacuuming "public.accountingitemaccounts"
INFO: vacuuming "public.accountingcategories"
INFO: vacuuming "public.accountingitems"

i'm using postgresql 9.0.4 on gentoo linux. i tried postgresql
documentation, google, as well as searching postgresql mailing list but
found no info on this, so sorry if this is duplicate question or obvious
thing.

miroslav

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2011-06-30 14:28:09 Re: When the Session ends in PGSQL?
Previous Message Durumdara 2011-06-30 14:11:32 When the Session ends in PGSQL?