Re: Koji vacuuming

[Toshio Kuratomi <a.badger@xxxxxxxxx>]

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

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list