Re: postgresql locks the whole table! - Mailing list pgsql-general

From Mike Mascari
Subject Re: postgresql locks the whole table!
Date
Msg-id 3FD37662.80603@mascari.com
Whole thread Raw
In response to Re: postgresql locks the whole table!  (Greg Stark <gsstark@mit.edu>)
Responses Re: postgresql locks the whole table!
List pgsql-general
Greg Stark wrote:
> It's not strictly necessary to have a list of all xids at all. The normal
> "shared read lock" is just "take the write lock, increment the readers
> counter, unlock" Anyone who wants to write has to wait (using, eg, a condition
> variable) until the readers count goes to 0.
>
> This gets the right semantics but without the debugging info of a list of
> lockers. Other than debugging the only advantage I see to having the list of
> lockers is for deadlock detection. Is that absolutely mandatory?

What happens if a backend is killed and never decrements its reference
count?

Mike Mascari
mascarm@mascari.com


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: postgresql locks the whole table!
Next
From: Stephan Szabo
Date:
Subject: Re: postgresql locks the whole table!