Re: SIREAD lock versus ACCESS EXCLUSIVE lock

On 03.06.2011 23:44, Kevin Grittner wrote:
> Heikki Linnakangas<heikki.linnakangas@enterprisedb.com>  wrote:
>
>> I think you'll need to just memorize the lock deletion command in
>> a backend-local list, and perform the deletion in a post-commit
>> function.
>
> Hmm.  As mentioned earlier in the thread, cleaning these up doesn't
> actually have any benefit beyond freeing space in the predicate
> locking collections.  I'm not sure that benefit is enough to justify
> this much new mechanism.  Maybe I should just leave them alone and
> let them get cleaned up in due course with the rest of the locks.
> Any opinions on that?

Is there a chance of false positives if oid wraparound happens and a new 
table gets the same oid as the old one? It's also possible for a heap to 
get the OID of an old index or vice versa, will that confuse things?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com