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?
pgsql-novice by date
|Next:||From: Ashish Karalkar||Date: 2007-08-07 08:07:50|
|Subject: Re: JOINING TWO TABLES|
|Previous:||From: Jon Sime||Date: 2007-08-07 00:18:05|
|Subject: Re: clustering and denormalizing with PostgreSQL?|