Re: pgfouine - commit details? - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: pgfouine - commit details?
Date
Msg-id 1d4e0c10805061731s30268f12p5a327a2df2e5a386@mail.gmail.com
Whole thread Raw
In response to pgfouine - commit details?  ("Josh Cole" <Josh.Cole@t8design.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Dennis Muhlestein
Date:
Subject: Re: Possible Redundancy/Performance Solution
Next
From: Vlad Arkhipov
Date:
Subject: Re: Seqscan problem