Re: Partial index locks

Thom Brown <thom(at)linux(dot)com> writes:
> Is it necessary for a partial index that doesn't include the row to be
> involved in locking?

Yes. You can't determine whether the index needs to get a new entry
without examining its metadata, and that's what the lock is mainly about.

The only possible alternative would be to take the minimum possible
lock (AccessShareLock) on each index so its metadata would hold still,
and then upgrade that to RowExclusiveLock on the one(s) we find need
insertions. This is not better; it means *more* lock management traffic
not less, and lock upgrades increase the potential for deadlocks.

regards, tom lane