[OPEN-ILS-DEV] Best guess db Vacuum process

Grant Johnson fgjohnson at upei.ca
Sat Oct 30 09:56:07 EDT 2010


Hey all,

I have some WAY too long delayed maintenance to do.

There is 9 GB free space on our hard drive.
 The Evergreen db directory is 21GB.
 What kind of "work space" should I expect during a  VACUUM-FULL of
the metabib.real_full_rec table?

I am concerned that I will run out of disk space during the process.

Thanks

Here's an VACUUM analysis...

INFO:  vacuuming "metabib.real_full_rec"
INFO:  scanned index "full_rec_pkey" to remove 2910333 row versions
DETAIL:  CPU 0.42s/5.80u sec elapsed 8.35 sec.
INFO:  scanned index "metabib_full_rec_record_idx" to remove 2910333
row versions
DETAIL:  CPU 0.46s/5.61u sec elapsed 9.36 sec.
INFO:  scanned index "metabib_full_rec_index_vector_idx" to remove
2910333 row versions
DETAIL:  CPU 0.82s/7.34u sec elapsed 21.83 sec.
INFO:  scanned index "metabib_full_rec_tag_subfield_idx" to remove
2910333 row versions
DETAIL:  CPU 1.14s/6.52u sec elapsed 26.18 sec.
INFO:  scanned index "metabib_full_rec_value_idx" to remove 2910333 row versions
DETAIL:  CPU 2.29s/10.12u sec elapsed 76.25 sec.
INFO:  scanned index "metabib_full_rec_value_tpo_index" to remove
2910333 row versions
DETAIL:  CPU 2.15s/10.01u sec elapsed 53.09 sec.
INFO:  "real_full_rec": removed 2910333 row versions in 86860 pages
DETAIL:  CPU 1.69s/1.70u sec elapsed 58.42 sec.
INFO:  index "full_rec_pkey" now contains 22350198 row versions in 72328 pages
DETAIL:  1320092 index row versions were removed.
19 index pages have been deleted, 2 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "metabib_full_rec_record_idx" now contains 22350198 row
versions in 74106 pages
DETAIL:  1310269 index row versions were removed.
2 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "metabib_full_rec_index_vector_idx" now contains 22350198
row versions in 122977 pages
DETAIL:  1320092 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.42s/0.14u sec elapsed 0.56 sec.
INFO:  index "metabib_full_rec_tag_subfield_idx" now contains 22350198
row versions in 118960 pages
DETAIL:  1320092 index row versions were removed.
5540 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "metabib_full_rec_value_idx" now contains 22350198 row
versions in 161561 pages
DETAIL:  1320092 index row versions were removed.
1561 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "metabib_full_rec_value_tpo_index" now contains 22350198
row versions in 149940 pages
DETAIL:  1320092 index row versions were removed.
1554 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "real_full_rec": found 2910333 removable, 22350198 nonremovable
row versions in 476714 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 686733 unused item pointers.
102429 pages contain useful free space.
0 pages are entirely empty.
CPU 11.13s/48.20u sec elapsed 256.75 sec.
INFO:  vacuuming "pg_toast.pg_toast_43352"
INFO:  scanned index "pg_toast_43352_index" to remove 983 row versions
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_43352": removed 983 row versions in 374 pages
DETAIL:  CPU 0.00s/0.01u sec elapsed 0.01 sec.
INFO:  index "pg_toast_43352_index" now contains 5141 row versions in 20 pages
DETAIL:  983 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.
INFO:  "pg_toast_43352": found 983 removable, 5141 nonremovable row
versions in 1276 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 18 unused item pointers.
587 pages contain useful free space.
0 pages are entirely empty.
CPU 0.01s/0.01u sec elapsed 0.51 sec.
INFO:  analyzing "metabib.real_full_rec"
INFO:  "real_full_rec": scanned 30000 of 476715 pages, containing
1402282 live rows and 0 dead rows; 30000 rows in sample, 22282962
estimated total rows
Total query runtime: 259089 ms.

-- 
F. Grant Johnson
Systems Manager - Robertson Library

email : fgjohnson at upei.ca, phone: 566-0630
cell: 393-4920
skype: jetsongeorge | twitter: fgjohnson | facebook: fgjohnson | blog:
granitize.blogspot.com


More information about the Open-ils-dev mailing list