StartTransact back at Debug2 in v8?

From: SZŰCS Gábor <surrano(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: StartTransact back at Debug2 in v8?
Date: 2005-01-11 13:13:38
Message-ID: 41E3D102.6070502@mailbox.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Gurus,

Please point me to the right way to find the answer, if it's already
answered, and forward the mail to the right list if I missed.

Also, please CC: answers to me, since I'm unsure if I'm subscribed to the
list right now... ;)

In v7.3, our logfiles got bloated by Start/CommitTransactionCommand.

In v7.4, this could be eliminated by a loglevel of DEBUG2, which showed
user-level debug, but not these Start/CommitTransact DEBUG messages.

In 8.0.0rc4 I'm sad to see that not only they are back to the same DEBUG
level (DEBUG2), but it's even more verbose.

Is there a way to configure the log differently, or is there an easy way to
modify the source to do so (e.g. degrading these annoying messages to DEBUG3?

Below is part of my postgresql.conf and a log piece.

TIA,
--
G.

-------- begin postgresql.conf snippet ---------
# - When to Log -

#log_min_messages = notice # Values, in order of decreasing detail:
log_min_messages = debug2

#log_min_error_statement = panic # Values in order of increasing severity:
log_min_error_statement=error

# - What to Log -

#log_connections = false
log_connections = true

#log_line_prefix = '' # e.g. '<%u%%%d> '
log_line_prefix = '%t [%p] %q[%u(at)%d] '
-------- endof postgresql.conf snippet ---------
-------- begin log snippet ---------
2005-01-11 13:52:25 CET [19185] [postgres(at)tir] DEBUG: StartTransaction
2005-01-11 13:52:25 CET [19185] [postgres(at)tir] DEBUG: name: unnamed;
blockState: DEFAULT; state: INPROGR, xid/subid/cid: 2081/1/0,
nestlvl: 1, children: <>
2005-01-11 13:52:25 CET [19185] [postgres(at)tir] DEBUG: CommitTransaction
-------- endof log snippet ---------

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2005-01-11 13:18:20 Re: to_char(0,'9999.99') -> ".00"
Previous Message Jason Tesser 2005-01-11 12:43:43 views in 8.0