Skip site navigation (1) Skip section navigation (2)

buffer page lock vs tuple lock (?)

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: buffer page lock vs tuple lock (?)
Date: 2007-08-07 07:52:40
Message-ID: 200708070952.40357.fluca1978@infinito.it (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Ashish KaralkarDate: 2007-08-07 08:07:50
Subject: Re: JOINING TWO TABLES
Previous:From: Jon SimeDate: 2007-08-07 00:18:05
Subject: Re: clustering and denormalizing with PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group