| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Greg Stark <gsstark(at)MIT(dot)EDU> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: server auto-restarts and ipcs |
| Date: | 2004-11-09 21:36:17 |
| Message-ID: | 5353.1100036177@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Greg Stark <gsstark(at)MIT(dot)EDU> writes:
> 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.
This seems to square with Ed's complaint that he frequently sees a
collision after a reboot. I've just committed some code that makes a
more extensive check as to whether a pre-existing segment actually has
any relevance to our data directory; should fix the problem.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ru.igarashi | 2004-11-09 21:37:43 | Re: Important Info on comp.databases.postgresql.general |
| Previous Message | Robert Treat | 2004-11-09 21:13:41 | Re: [GENERAL] FTP mirror problems |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-09 22:27:14 | A modest proposal: get rid of GUC's USERLIMIT variable category |
| Previous Message | Greg Stark | 2004-11-09 20:52:39 | Re: server auto-restarts and ipcs |