[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Koji vacuuming



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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]