View Single Post

   
  #2 (permalink)  
Old 05-07-2008, 10:19 AM
Guillaume Smet
 
Posts: n/a
Default Re: pgfouine - commit details?

Josh,

On Tue, May 6, 2008 at 11:10 PM, Josh Cole <Josh.Cole@t8design.com> 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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply With Quote