Re: Problems with extended-Query logging code
| От | Abhijit Menon-Sen |
|---|---|
| Тема | Re: Problems with extended-Query logging code |
| Дата | |
| Msg-id | 20060907005646.GA28998@penne.toroid.org обсуждение |
| Ответ на | Problems with extended-Query logging code (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-hackers |
At 2006-09-06 18:01:38 -0400, tgl@sss.pgh.pa.us 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
В списке pgsql-hackers по дате отправления: