buffer page lock vs tuple lock (?) - Mailing list pgsql-novice

From Luca Ferrari
Subject buffer page lock vs tuple lock (?)
Date
Msg-id 200708070952.40357.fluca1978@infinito.it
Whole thread Raw
Responses Re: buffer page lock vs tuple lock (?)
List pgsql-novice
Hi,
if I get it right a heap buffer page (that contains several tuples) requires a
pin and a lock to access the page content, and a change to a tuple requires a
lock on the tuple too. Disregarding some cases (tuple shuffling within the
same page and vacuum) does not this double locking be too much? I mean, does
not suffice to pin the page and lock the tuple (e.g., reading)?
Can anybody help me understanding?

Thanks,
Luca

pgsql-novice by date:

Previous
From: Jon Sime
Date:
Subject: Re: clustering and denormalizing with PostgreSQL?
Next
From: "Ashish Karalkar"
Date:
Subject: Re: JOINING TWO TABLES