6 ms·
> Multiple readers are okay but a single writer will cause transient errors in all other concurrent read and write operations They don't cause "transient error
by gwd 2y ago
> Multiple readers are okay but a single writer will cause transient errors in all other concurrent read and write operations
They don't cause "transient errors", they cause transaction failures, which you should be handling by retrying the transaction anyway.
- kbolino 2y agoIf you could retry it, then obviously the error was transient. I don't know what the issue is with me describing it that way. But you generally won't have to write retry logic if you have the file open in only one place. The other issues that can arise, like constraint violations or no space left on disk, usually aren't transient and thus can't be fixed with retry anyway.