Re: Can I truncate statements in the log? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Can I truncate statements in the log?
Date
Msg-id 200809061738.m86Hc0a06071@momjian.us
Whole thread Raw
In response to Can I truncate statements in the log?  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Howard Cole wrote:
> As part of my log configuration, I log statements that take over 3
> seconds. I find this very useful for optimising tables etc. The problem
> is that it produces verbatim some very large statements which can create
> huge log entries, which are probably responsible themselves for slowing
> the system down. The problem tend to be insert statements for binary
> objects - which can be Megabytes long.
>
> Is it possible to stop logging these excessive insert statements
> somehow, or restricting the log of statements to select, delete etc and
> ignore inserts.

No, sorry.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: "rkmr.em@gmail.com"
Date:
Subject: Re: storing repeating dates / events
Next
From: Jorge Godoy
Date:
Subject: Re: storing repeating dates / events