It should be so rare that if it did happen, you likely have a serious bug somewhere. Crash dumping and investigating is the right course of action, not building in retry logic.
So if you are using it as a PK
value, only ever insert and if there is a duplicate, blow up
loudly.
Performance wise, that isn’t particularly impactful IMO.
So if you are using it as a PK value, only ever insert and if there is a duplicate, blow up loudly.
Performance wise, that isn’t particularly impactful IMO.