Re: Patch: show relation and tuple infos of a lock to acquire - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Patch: show relation and tuple infos of a lock to acquire
Date
Msg-id 20140102095501.GA22496@awork2.anarazel.de
Whole thread Raw
In response to Re: Patch: show relation and tuple infos of a lock to acquire  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 2014-01-02 01:40:38 -0800, Peter Geoghegan wrote:
> On Thu, Jan 2, 2014 at 12:56 AM, Andres Freund <andres@2ndquadrant.com> wrote:
> > I agree that the message needs improvement, but I don't agree that we
> > shouldn't lock the tuple's location. If you manually investigate the
> > situation that's where you'll find the conflicting tuple - I don't see
> > what we gain by not logging the ctid.
> 
> I suppose so, but the tuple probably isn't going to be visible anyway,
> at least when the message is initially logged.

But that's the case for all these, otherwise we wouldn't wait on the
row.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Next
From: Peter Geoghegan
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE