Re: Query using partitioned table hangs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rob W <digital_illuminati(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query using partitioned table hangs
Date: 2009-12-07 17:11:31
Message-ID: 6531.1260205891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rob W <digital_illuminati(at)yahoo(dot)com> writes:
> A re-post, since I'm really stuck on this and could use some advice on how to troubleshoot this...

Have you looked into pg_locks to see if it's blocked waiting for a lock?
The TRUNCATE in particular would require exclusive lock on the table,
so it could be waiting for some other process that's touched the table.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-12-07 17:39:14 Re: Use a blob or not?
Previous Message Daniel 2009-12-07 17:07:49 Use a blob or not?