We are shipping the postgres.log to a remote syslog repository to take the I/O burden off our postgresql server. As such if we set log_min_duration_statement to 0 this allow us to get more detailed information about our commits using pgfouine...correct? -- Josh
________________________________ From: Guillaume Smet [mailto:[EMAIL PROTECTED] Sent: Tue 5/6/2008 7:31 PM To: Josh Cole Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] pgfouine - commit details? Josh, On Tue, May 6, 2008 at 11:10 PM, Josh Cole <[EMAIL PROTECTED]> wrote: > We are using pgfouine to try and optimize our database at this time. Is > there a way to have pgfouine show examples or breakout commits? I hesitated before not implementing this idea. The problem is that you often don't log everything and use log_min_duration_statement and thus you don't have all the queries of the transaction in your log file (and you usually don't have the BEGIN; command in the logs). -- Guillaume
