Tom Lane wrote:
Manfred Koizar [EMAIL PROTECTED] writes:
Yes, the visible-to-all flag would be set as a by-product of an index
scan, if the heap tuple is found to be visible to all active
transactions. This update is non-critical
Oh really? I think you need to think harder about the transition
Jochem van Dieten [EMAIL PROTECTED] writes:
The moment the heap tuple is updated/deleted the visible-to-all
flag needs to be set to false again in all indexes. This is
critical,
Exactly. This gets you out of the hint-bit semantics and into a ton
of interesting problems, such as race
No, don't go away and be quiet. Keep testing, it may be that under
normal operation the context switching goes up but under the conditions
that you were seeing the high CS it may not be as bad.
As others have mentioned the real solution to this is to rewrite the
buffer management so that the lock