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

From Andrew Dunstan
Subject Re: [PATCHES] log session end - again
Date
Msg-id 40225479.2040305@dunslane.net
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  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers

Bruce Momjian wrote:

>Tom Lane wrote:
>  
>
>>Larry's idea about combining PID and backend start time didn't sound too
>>unreasonable to me.
>>    
>>
>
>Wow, like the idea too --- pid plus time_t start time of backend. 
>Actully, it would be good to have star time first so you can sort
>everything in order of start time.
>  
>

Yes. Of course, you would need either to sort additionally on log 
timestamp or use an order-preserving sort.

Based on Larry's idea, I had in mind to provide a third escape in the 
log_line_info string (in addition to the %U and %D that I had previously 
done) of %S for sessionid, which would look something like this: 
402251fc.713f

I will start redoing this feature when the log_disconnections patch is 
dealt with.

cheers

andrew



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] log session end - again
Next
From: Bruce Momjian
Date:
Subject: Re: PITR Dead horse?