From: | Joe Maldonado <jmaldonado(at)webehosting(dot)biz> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: TRUNCATE locking problem |
Date: | 2005-07-21 14:15:07 |
Message-ID: | 42DFADEB.9010708@webehosting.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>Joe Maldonado <jmaldonado(at)webehosting(dot)biz> writes:
>
>
>>While researching this locking issue I got some of the logs and found
>>that in one of the cases there was a SELECT running for a long time,
>>about 2 hours. This select statement does not usually take more than a
>>few seconds though, it appeared that TRUNCATE was waiting on it to
>>finish before continuing.
>>
>>
>
>
>
>>The SELECT statement in question contains a sub SELECT in the FROM
>>clause which in turn is joining with a view that contains the table
>>which TRUNCATE is being executed against.
>>
>>
>
>
>
>>Is it possible that the SELECT was issues just before the TRUNCATE
>>statement was issues and the view in the sub SELECT was waiting on
>>TRUNCATE's lock?
>>
>>
>
>No. That would be a deadlock and would be reported as such.
>
> regards, tom lane
>
>
Again many thanks :)
- Joe Maldonado
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-07-21 14:17:40 | Re: Wishlist? |
Previous Message | Tom Lane | 2005-07-21 14:08:37 | Re: TRUNCATE locking problem |