From: Guillaume Smet <guillaume.smet@gmail.com>
To: Josh Cole <Josh.Cole@t8design.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pgfouine - commit details?
Date: Wed, 7 May 2008 02:31:52 +0200
Message-ID: <1d4e0c10805061731s30268f12p5a327a2df2e5a386@mail.gmail.com> (raw)
In-Reply-To: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com>
References: <9A53DDE1FE082F4D952FDF20AC87E21F7FD816@exchange2.t8design.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume.smet@gmail.com, Josh.Cole@t8design.com
Subject: Re: pgfouine - commit details?
In-Reply-To: <1d4e0c10805061731s30268f12p5a327a2df2e5a386@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox