Re: pgfouine - commit details?
| От | Josh Cole |
|---|---|
| Тема | Re: pgfouine - commit details? |
| Дата | |
| Msg-id | 9A53DDE1FE082F4D952FDF20AC87E21F3E8006@exchange2.t8design.com обсуждение исходный текст |
| Ответ на | pgfouine - commit details? ("Josh Cole" <Josh.Cole@t8design.com>) |
| Список | pgsql-performance |
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:guillaume.smet@gmail.com]
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 <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 по дате отправления: