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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
