>>>>
>>>
>>> Current FK checking makes you wait if the referenced tuple is modified
>>> on any indexed column, not just those that are actually used in
>>> foreign keys. Maybe this case would be sped up if we optimized that.
>>
>> Even if it is an gin index that is being modified? seems like a harsh limitation to me.
>
> Well, as I recall it's only unique indexes, so it's not *that* harsh.
>
Sounds good. Indices are there for all kinds of reasons, unique ones are more related to referential integrity, so
evennot 100% accurate, at least 90% of the way in my world.
We do have an "star"-schema in the db with some amount of information needed in the center that needs updates, apart
fromthat a massive update activity on the sorrounding columns, locks on the center entity has quite high impact on the
sorroundingupdates. (9.2 moving to 9.3 reallly soon and looking forward for this enhancement.
Jesper