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

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 (view raw or flat)
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

pgsql-hackers by date

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

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