Horton

Re: BUG #1333: vacuum full apparently fails to complete

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Keith Halewood" <keith_halewood@systems-intelligence.com>
Cc: pgsql-bugs@postgresql.org
Date: 2004-11-30T16:40:23Z
Lists: pgsql-bugs 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> At this point, the vacuum is *still* in progress (after 8 hours) and disc 
> activity is exclusively the result of this vacuum, about 140 blocks/second 
> with no disc queues. Is this likely to be a bug or just a scalability issue 
> involving vacuum and the large object table? 

vacuum full can take an awfully long time.  It might be worth your while
to try a CLUSTER instead.

			regards, tom lane