Koji vacuuming
Toshio Kuratomi
a.badger at gmail.com
Tue Jan 29 21:41:52 UTC 2008
Results of running time vacuum analyze over the newly vacuumed rpmfiles db:
real 807m15.694s
user 0m0.084s
sys 0m0.020s
Devrim suggested we increase maintenance_work_mem to 1GB which I've done
in the configs. That won't go live until we have an opportunity to
restart the postgres server. That parameter will allow vacuums, create
index, and other "maintenance" functions to use up to 1GB of memory when
they are running.
Full Log:
[toshio at db2 ~]$ time echo 'vacuum analyze verbose rpmfiles' | sudo -u
postgres
psql -d koji
INFO: vacuuming "public.rpmfiles"
INFO: index "rpmfiles_by_rpm_id" now contains 99710482 row versions in
464395
pages
DETAIL: 125033 index pages have been deleted, 125033 are currently
reusable.
CPU 3.51s/0.76u sec elapsed 1789.79 sec.
INFO: index "rpmfiles_by_filename" now contains 99739365 row versions
in 2162
981 pages
DETAIL: 316678 index pages have been deleted, 316678 are currently
reusable.
CPU 74.13s/16.68u sec elapsed 18957.20 sec.
INFO: index "rpmfiles_pkey" now contains 99912850 row versions in
2451399 pages
DETAIL: 342208 index pages have been deleted, 342208 are currently
reusable.
CPU 70.60s/13.16u sec elapsed 24427.02 sec.
INFO: "rpmfiles": found 0 removable, 99693793 nonremovable row versions
in 24
67550 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 35028550 unused item pointers.
0 pages are entirely empty.
CPU 152.49s/31.79u sec elapsed 46435.11 sec.
INFO: vacuuming "pg_toast.pg_toast_396022"
INFO: index "pg_toast_396022_index" now contains 0 row versions in 1 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO: "pg_toast_396022": found 0 removable, 0 nonremovable row versions
in 0 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.03 sec.
INFO: analyzing "public.rpmfiles"
INFO: "rpmfiles": scanned 90000 of 2467550 pages, containing 3662103
live rows and 0 dead rows; 90000 rows in sample, 100404692 estimated
total rows
VACUUM
real 807m15.694s
user 0m0.084s
sys 0m0.020s
-Toshio
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/fedora-infrastructure-list/attachments/20080129/0d67d322/attachment.sig>
More information about the Fedora-infrastructure-list
mailing list