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

Re: Slow Vacuum was: vacuum output question

From: "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow Vacuum was: vacuum output question
Date: 2008-12-30 16:37:04
Message-ID: 82f04dc40812300837k12a27d48s21988b74900f8348@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
>> INFO:  "cpe": found 95498 removable, 18757 nonremovable row versions
>> in 11117 pages
>> DETAIL:  0 dead row versions cannot be removed yet.
>> There were 280173 unused item pointers.
>> 0 pages are entirely empty.
>> CPU 5.35s/0.99u sec elapsed 724.38 sec.
>
> How many idle transactions are there?
>

Not sure.  I don't expect that there were many, their system isn't
very highly loaded compared to most of our customers systems.

The way that they reported the problem to us was that if they enable
autovacuum, when ever it runs (about 4 times an hour) it would stop
processing the things it needed to process, due to table lock
contention for several minutes.

Their workaround had been to run a daily autovacuum at the lowest load
time of day, to cause the least disruption.

In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-12-30 16:47:17
Subject: Re: Slow Vacuum was: vacuum output question
Previous:From: Dan ArmbrustDate: 2008-12-30 16:32:07
Subject: Re: Slow Vacuum was: vacuum output question

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