Re: log_duration - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: log_duration
Date
Msg-id 20030213041018.GH1833@filer
Whole thread Raw
In response to Re: log_duration  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark wrote:
> Not a big deal though, since I doubt anyone's actually parsing
> postgres logs.  Hm, brings up an interesting idea though, I wonder
> if it would be useful to log directly into postgres tables.

I was wondering roughly the same thing.  If you ran an external
program to process the logs and put them into a PostgreSQL database,
you'd have problems with the transactions of the log processor landing
in the logs as well, at least if all transactions were logged.  The
logging process would have to filter out its own transactions, which
might not be all that easy.


-- 
Kevin Brown                          kevin@sysexperts.com


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: psql and readline
Next
From: Tom Lane
Date:
Subject: Re: log_duration