Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Buffer access rules, and a probable bug - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: Buffer access rules, and a probable bug
Date
Msg-id 2758.994341283@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Buffer access rules, and a probable bug  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Dead(HEAP_XMAX_COMMITTED || HEAP_XMIN_INVALID) tuples never
> revive. Live (not dead) tuples never die in Share Lock mode.

Hmm ... so you're relying on the ShareLock to ensure that the state of
the tuple can't change between when heap_fetch checks it and when
nbtree looks at it.

Okay, but put in some comments documenting what this stuff is doing
and why.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: stuck spin lock with many concurrent users
Next
From: Tom Lane
Date:
Subject: Re: AW: Strange query execution time