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
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? |