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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
