Re: Can I truncate statements in the log?

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: Can I truncate statements in the log?
Дата
Msg-id
200809061738.m86Hc0a06071@momjian.us
Ответ на
Список
Дерево обсуждения
Can I truncate statements in the log? Howard Cole <howardnews@selestial.com>
Re: Can I truncate statements in the log? Bruce Momjian <bruce@momjian.us>
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          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
В списке pgsql-general по дате отправления
От: rkmr.em@gmail.com
Дата:
От: Jorge Godoy
Дата:
FAQ