Re: slow slow query log - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: slow slow query log
Date
Msg-id 200812170218.56155@zmi.at
Whole thread Raw
In response to slow slow query log  ("Vladimir Rusinov" <vladimir@greenmice.info>)
List pgsql-admin
On Mittwoch 03 Dezember 2008 Vladimir Rusinov wrote:
> Is there any way to disable dumping query parameters to query log? It
> would be ok for us, if this would be just UPDATE table SET data=$1
> WHERE id=$2 on log, we don't need full text on log files.

I'd like to have that info too. If you run a bayes database from
spamassassin, a single log entry can take 50+ lines. A restriction to
the number of lines, or length, would be very nice.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4


Attachment

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Vacuum Problems
Next
From: Michael Monnerie
Date:
Subject: Re: reindexdb dying with SIGPIPE on 8.2.5