Re: server auto-restarts and ipcs

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: server auto-restarts and ipcs
Дата
Msg-id 874qjyiw2w.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: server auto-restarts and ipcs  (Greg Stark <gsstark@mit.edu>)
Ответы Re: server auto-restarts and ipcs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: troubleshooting deadlocks
Следующее
От: Mike Cox
Дата:
Сообщение: I'm about to release the next postgresql RFD. Comments wanted.