> 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. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
No comments:
Post a Comment