Re: [PATCHES] log session end - again

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: [PATCHES] log session end - again
Дата
Msg-id 40225479.2040305@dunslane.net
обсуждение исходный текст
Ответ на Re: [PATCHES] log session end - again  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [PATCHES] log session end - again  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] log session end - again
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PITR Dead horse?