From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TODO list |
Date: | 2004-01-06 21:54:27 |
Message-ID: | 3FFB2E93.1050907@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jon Jensen wrote:
>On Tue, 6 Jan 2004, Andrew Dunstan wrote:
>
>
>
>>>Also, I would like to see some kind of session identifier that is more
>>>unique than pid, which wraps around. Ideally we could have 10{pid},
>>>then then the pid wraps around, 20{pid), or something like that.
>>>
>>>
>>This requires some thought. ISTM it wouldn't buy you much unless you
>>made it persistent across server restarts, and possibly not even then.
>>
>>
>
>And on OpenBSD (though no other platforms that I know of) the PID is a
>random number, so there is no "wrapping" to begin with.
>
>
>
OK, so a sessionid based on prefix+pid won't work portably. If we
*really* want to do it, a cluster-wide sequence generator would probably
be the way to go, but I suspect that with the ability to log session
termination explicitly (which I have already provided) much of the
supposed extra utility would disappear anyway.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-01-06 21:59:03 | Re: Paypal WAS: PostgreSQL speakers needed for |
Previous Message | Keith C. Perry | 2004-01-06 21:53:32 | Re: Paypal |