Re: Help: 8.0.3 Vacuum of an empty table never completes ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Robinson <jlrobins(at)socialserve(dot)com>
Cc: Hackers Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Help: 8.0.3 Vacuum of an empty table never completes ...
Date: 2005-11-28 16:09:17
Message-ID: 10314.1133194157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

James Robinson <jlrobins(at)socialserve(dot)com> writes:
> Comparing the logs further with when it did complete, it seems that
> one table in particular (at least) seems afflicted:

> social=# vacuum verbose analyze agency.swlog_client;

> hangs up forever -- have to control-c the client. Likewise for w/o
> 'analyze'.

Given that it's not eating CPU time, one would guess that it's blocked
waiting for a lock. Can you find any relevant locks in pg_locks?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mario Weilguni 2005-11-28 16:13:01 Re: Getting different number of results when using hashjoin on/off
Previous Message James Robinson 2005-11-28 16:04:39 Help: 8.0.3 Vacuum of an empty table never completes ...