At 2006-09-06 18:01:38 -0400, [EMAIL PROTECTED] wrote:
>
> That is, we'd log a Parse or Bind operation if it individually
> exceeded the duration threshold, and not otherwise.
Ok.
> If we've got support for logging the statement text and the parameter
> values at Execute time, isn't logging the preliminary steps just
> bloating the log?
Agreed. Logging Parse/Bind only if they're particularly interesting
sounds good to me.
> * I think that the best way to log bind-parameter values is to run the
> datatype output functions on the saved parameter values. This works
> whether they were sent in text or binary mode, and avoids any extra
> overhead at Bind time that might not be repaid.
Great. (The logging of binary parameters is something I also... not
exactly _need_, but would be happy about.)
-- ams
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
