Re: server auto-restarts and ipcs - Mailing list pgsql-general

From Greg Stark
Subject Re: server auto-restarts and ipcs
Date
Msg-id 874qjyiw2w.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: server auto-restarts and ipcs  (Greg Stark <gsstark@mit.edu>)
Responses Re: server auto-restarts and ipcs
List pgsql-general
Greg Stark <gsstark@MIT.EDU> writes:

> At least in 2.6 it seems to avoid reuse of ids by keeping a global counter
> that is incremented every time a segment is created which ranges from 0..128k
> that it multiplies by 32k and adds to the array index (which is reused
> quickly).
>
> So it doesn't seem plausible that there was an id collision unless this was
> different in 2.4.20. However looking at his list of ids they're all separated
> by multiples of 32769 which is what you would expect from this algorithm at
> least until they start being reused.

Oh I missed the fact that you were talking about after a reboot. So the
algorithm I described would produce exactly the same sequence of ids after any
reboot given the same sequence of creation and deletions. Even if there's a
different sequence as long as the n'th creation is for the m'th array slot it
would get the same id. So collisions would be very common.

(though it seems the sequence is shared across all the ipc objects.)

--
greg

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: troubleshooting deadlocks
Next
From: Mike Cox
Date:
Subject: I'm about to release the next postgresql RFD. Comments wanted.