Skip site navigation (1) Skip section navigation (2)

Vacuum is looping on tables?

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum is looping on tables?
Date: 2004-10-19 17:08:29
Message-ID: 41754A0D.90606@rentec.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,

   I've noticed that vacuum seems to be looping around the same table, is this a expected behavior using v8 beta3?  It usually finishes, although the vacuums from last night are still running and appear to be stuck re-vacuuming the same table over and over.

-michael

INFO:  vacuuming "public.tblobjectcomposite"
INFO:  index "composite_memberid" now contains 92963959 row versions in 455237 pages
DETAIL:  2795966 index row versions were removed.
107325 index pages have been deleted, 101957 are currently reusable.
CPU 16.51s/30.88u sec elapsed 1720.69 sec.

INFO:  index "composite_uniqid" now contains 93772721 row versions in 530933 pages
DETAIL:  2795966 index row versions were removed.
130132 index pages have been deleted, 122698 are currently reusable.
CPU 21.62s/32.33u sec elapsed 4884.74 sec.

INFO:  "tblobjectcomposite": removed 2795966 row versions in 36537 pages
DETAIL:  CPU 2.61s/2.60u sec elapsed 135.03 sec.

INFO:  index "composite_memberid" now contains 91632382 row versions in 455489 pages
DETAIL:  2795921 index row versions were removed.
108064 index pages have been deleted, 96717 are currently reusable.
CPU 17.48s/30.88u sec elapsed 2611.86 sec.

INFO:  index "composite_uniqid" now contains 92855727 row versions in 531845 pages
DETAIL:  2795921 index row versions were removed.
131459 index pages have been deleted, 115959 are currently reusable.
CPU 20.57s/32.41u sec elapsed 5450.22 sec.

INFO:  "tblobjectcomposite": removed 2795921 row versions in 38614 pages
DETAIL:  CPU 2.61s/2.55u sec elapsed 61.30 sec.

INFO:  index "composite_memberid" now contains 90962114 row versions in 455489 pages
DETAIL:  2795940 index row versions were removed.
108178 index pages have been deleted, 88662 are currently reusable.
CPU 16.93s/30.51u sec elapsed 2251.60 sec.

INFO:  index "composite_uniqid" now contains 92119331 row versions in 531845 pages
DETAIL:  2795940 index row versions were removed.
131641 index pages have been deleted, 107530 are currently reusable.
CPU 19.11s/31.42u sec elapsed 3131.87 sec.

INFO:  "tblobjectcomposite": removed 2795940 row versions in 37718 pages
DETAIL:  CPU 2.41s/2.57u sec elapsed 50.12 sec.

INFO:  index "composite_memberid" now contains 90044879 row versions in 455489 pages
DETAIL:  2795937 index row versions were removed.
111488 index pages have been deleted, 81635 are currently reusable.
CPU 16.61s/29.90u sec elapsed 1813.86 sec.

INFO:  index "composite_uniqid" now contains 90714236 row versions in 531845 pages
DETAIL:  2795937 index row versions were removed.
137468 index pages have been deleted, 101912 are currently reusable.
CPU 19.52s/30.73u sec elapsed 2786.30 sec.

INFO:  "tblobjectcomposite": removed 2795937 row versions in 39211 pages
DETAIL:  CPU 2.38s/2.67u sec elapsed 87.91 sec.
INFO:  index "composite_memberid" now contains 88496715 row versions in 455489 pages
DETAIL:  2795939 index row versions were removed.
117229 index pages have been deleted, 76785 are currently reusable.
CPU 16.09s/32.62u sec elapsed 1488.13 sec.
INFO:  index "composite_uniqid" now contains 88985708 row versions in 531845 pages
DETAIL:  2795939 index row versions were removed.
145309 index pages have been deleted, 98186 are currently reusable.
CPU 18.72s/32.60u sec elapsed 2164.92 sec.
INFO:  "tblobjectcomposite": removed 2795939 row versions in 38721 pages
DETAIL:  CPU 2.76s/2.57u sec elapsed 44.62 sec.
INFO:  index "composite_memberid" now contains 86442627 row versions in 455489 pages
DETAIL:  2795933 index row versions were removed.
124298 index pages have been deleted, 74126 are currently reusable.
CPU 14.86s/29.16u sec elapsed 1274.84 sec.
INFO:  index "composite_uniqid" now contains 86589271 row versions in 531845 pages
DETAIL:  2795933 index row versions were removed.
155604 index pages have been deleted, 96914 are currently reusable.
CPU 18.71s/29.62u sec elapsed 2248.86 sec.
INFO:  "tblobjectcomposite": removed 2795933 row versions in 39913 pages
DETAIL:  CPU 2.67s/2.70u sec elapsed 68.99 sec.
INFO:  index "composite_memberid" now contains 83793355 row versions in 455489 pages
DETAIL:  2795916 index row versions were removed.
134830 index pages have been deleted, 73569 are currently reusable.
CPU 13.77s/28.88u sec elapsed 901.72 sec.
INFO:  index "composite_uniqid" now contains 83841890 row versions in 531845 pages
DETAIL:  2795916 index row versions were removed.
167546 index pages have been deleted, 96693 are currently reusable.
CPU 17.47s/29.18u sec elapsed 1607.66 sec.
INFO:  "tblobjectcomposite": removed 2795916 row versions in 41064 pages
DETAIL:  CPU 2.67s/2.73u sec elapsed 36.38 sec.


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2004-10-19 17:22:21
Subject: Re: Vacuum is looping on tables?
Previous:From: Keith WorthingtonDate: 2004-10-19 16:33:42
Subject: Re: finding data violating constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group