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

From Bruce Momjian
Subject Re: [PATCHES] log session end - again
Date
Msg-id 200402031614.i13GEY310454@candle.pha.pa.us
Whole thread Raw
In response to Re: [PATCHES] log session end - again  ("Andrew Dunstan" <andrew@dunslane.net>)
Responses Re: [PATCHES] log session end - again  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Andrew Dunstan wrote:
> Tom Lane said:
> > Andrew Dunstan <andrew@dunslane.net> writes:
> >> I'm not sure I understand. I didn't suggest that a sequence should be
> >> used for txn ids. For the purpose I had in mind we would call
> >> nextval()  once per connection,
> >
> > Oh, okay, I misunderstood.  But why not just use the PID?
> >
> 
> Bruce and others have suggested that PID is not sufficiently unique.
> Personally, I can live with it :-)
The nice things about using xid for session id is that is is unique for
a long time, rather than pid.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Idea about better configuration options for sort memory
Next
From: Bruce Momjian
Date:
Subject: Re: pg_restore bug in 7.4.1 ?