Exec statement logging
От | Simon Riggs |
---|---|
Тема | Exec statement logging |
Дата | |
Msg-id | 1113255665.16721.1270.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Exec statement logging
Re: Exec statement logging |
Список | pgsql-patches |
Following patch is a minor addition to postgres.c that allows the two existing statement logging techniques to work with V3 exec. This then allows statement logging with PostgreSQL 8.0+ for JDBC and other V3 connection types. The rationale of this patch is to add functionality without modifying existing behaviour. There is expected to be some difficulty with log_statement producing a log line at both parse and exec, but some may find that useful. Since there are two ways of producing statement logging with duration times, setting log_min_duration_statement=0 will avoid the logging of statements for both parse and exec. For many this method is already the preferred way of logging statement performance stats. There is no attempt to log parameters, since these are not often required for performance analysis. The enclosed patch has been tested against cvstip. I also see this as a backpatch onto 8.0, since it prevents statements from being logged as described in the manual and prevents effective performance tuning. It has not been tested against 8.0.2, though was originally written against 8.0.1 and is believed to apply cleanly. Some code has been duplicated with this patch; refactoring and cleanup can be performed should anybody desire it. The patch was produced quickly to assist tuning efforts during Scalability & Performance benchmarking of PostgreSQL 8.0 carried out at Unisys Corporation's Mission Viejo engineering laboratory. The development was sponsored by Unisys Corporation and the patch has now been donated to the PostgreSQL community under the standard PostgreSQL/BSD licence. Approval for release of this code has been given in writing to me by the Director, Open Runtime Products, Unisys on April 8, 2005. Best Regards, Simon Riggs
Вложения
В списке pgsql-patches по дате отправления: