Re: RFC: built-in historical query time profiling - Mailing list pgsql-hackers

From Ed L.
Subject Re: RFC: built-in historical query time profiling
Date
Msg-id 200503231651.25871.pgsql@bluepolka.net
Whole thread Raw
In response to Re: RFC: built-in historical query time profiling  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wednesday March 23 2005 3:34, Tom Lane wrote:
>
> This is going to fall down on exactly the same objections that
> have been made to putting the log messages themselves into
> tables.  The worst one is that a failed transaction would fail
> to make any entry whatsoever. There are also performance,
> locking, and security issues to think about. (Example: heaven
> help you if someone decides to VACUUM FULL the log table ---
> that would block every other process due to exclusive lock.)

I see your point.  The ugliness of log-parsing beckons.

Thanks.
Ed



pgsql-hackers by date:

Previous
From: "Ed L."
Date:
Subject: Re: RFC: built-in historical query time profiling
Next
From: Mark Wong
Date:
Subject: Re: WAL: O_DIRECT and multipage-writer