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                        |
  [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

Reply via email to