Re: [HACKERS] 'Waiting on lock'

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "pgsql-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] 'Waiting on lock'
Date: 2007-06-19 12:33:25
Message-ID: 87fy4o86p6.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

"Gregory Stark" <stark(at)enterprisedb(dot)com> writes:

> Incidentally in looking at this I found that the "early deadlock detection"
> never seems to fire. Reading the source it seems it ought to be firing
> whenever we have a simple two-process deadlock. But instead I only get the
> timeout-based detection.

Ok, I understand now that early deadlock detection only kicks in when doing
something like LOCK TABLE and even then only if you're deadlocking because
you're upgrading a lock. So this works as intended though it's much less
useful than I thought.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Magnus Hagander 2007-06-19 13:04:11 Re: Preliminary GSSAPI Patches
Previous Message Heikki Linnakangas 2007-06-19 12:04:24 Re: Load Distributed Checkpoints, revised patch