"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Yeah. If we did want to do something more, we could acquire the lock on > vid conditionally, and use another vid if acquiring the lock fails. But > I don't think it's necessary.
I was thinking more along the lines of looking through the ProcArray at backend startup to ensure the sessionID we've chosen is unique, and choosing another one if not. But this would expend cycles with the ProcArray locked, for something that seems exceedingly unlikely to happen, regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend