Re: session id and global storage

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <hannu(at)skype(dot)net>
Cc: <david(dot)hoksza(at)seznam(dot)cz>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: session id and global storage
Date: 2006-06-01 10:53:05
Message-ID: 2568.24.211.165.134.1149159185.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing said:
> Ühel kenal päeval, N, 2006-06-01 kell 10:10, kirjutas David Hoksza:
>> It seems MyProcID is what I was searching for...
>>
>
> On a buzy server with lots of connects, procID will repeat quite often.
>

log_line-prefix has a sessionid gadget:

Session ID: A unique identifier for each session. It is 2 4-byte hexadecimal
numbers (without leading zeros) separated by a dot. The numbers are the
session start time and the process ID

Assuming PIDs are not reused within one second that will be unique.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2006-06-01 11:46:56 Re: [PATCH] Magic block for modules
Previous Message Hannu Krosing 2006-06-01 09:16:37 Re: session id and global storage