Re: pgfouine - commit details?

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Josh Cole" <Josh(dot)Cole(at)t8design(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pgfouine - commit details?
Date: 2008-05-07 00:31:52
Message-ID: 1d4e0c10805061731s30268f12p5a327a2df2e5a386@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh,

On Tue, May 6, 2008 at 11:10 PM, Josh Cole <Josh(dot)Cole(at)t8design(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vlad Arkhipov 2008-05-07 00:48:36 Re: Seqscan problem
Previous Message Dennis Muhlestein 2008-05-06 21:39:02 Re: Possible Redundancy/Performance Solution