Re: [PATCHES] log session end - again - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] log session end - again
Date
Msg-id 19327.1075827366@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] log session end - again  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] log session end - again  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Andrew Dunstan wrote:
>> Bruce and others have suggested that PID is not sufficiently unique.
> The nice things about using xid for session id is that is is unique for
> a long time, rather than pid.

Hmm.  Now that I think about it, InitPostgres() always runs a
transaction during backend startup.  If we simply saved aside the XID
assigned to that transaction, it would cost next to nothing to do and
would provide a reasonably unique ID.  However, this happens much later
than the postmaster currently prints the log_connection message ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Why has postmaster shutdown gotten so slow?
Next
From: Bruce Momjian
Date:
Subject: Re: pg_restore bug in 7.4.1 ?