"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2004-11-30 16:53:09|
|Subject: Re: Out of memory while UPDATE some_table ... FROM some_view (8.0 beta5) |
|Previous:||From: Stephan Heilner||Date: 2004-11-30 15:52:19|
|Subject: service doesn't start|