Peter Eisentraut wrote: > Tom Lane writes: > > > Sure it can. You're essentially arguing that DBAs are too dumb to match > > up matching query and duration log outputs. I don't buy that. I think > > they'll be analyzing their logs with little Perl scripts anyway, and > > that consistency of log output format will be worth more to those > > scripts than sometimes having related items all on one log line. > > When you're dealing with a large installation, these little Perl scripts > become difficult. I've just had to deal with a similar issue with a > popular MTA which spreads the relevant log information over several lines. > If you're generating 500 MB of log output a day, it becomes a problem.
I can imagine. I wasn't sure how I would write Perl code to join things via pid. I am sure it can be done (load into hash), but it wasn't trivial like grep. Peter, any problems with pid wrap-around? I am thinking we need to prepend a "wrap count" on the front of the pid output for 7.5. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly