Re: Expensive log_line_prefix ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Expensive log_line_prefix ?
Дата
Msg-id 1312.1349993880@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Expensive log_line_prefix ?  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: Expensive log_line_prefix ?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Sergey Konoplev <gray.ru@gmail.com> writes:
> On Thu, Oct 11, 2012 at 12:19 PM, Sahagian, David
> <david.sahagian@emc.com> wrote:
>> Are there any "extra" costs to logging all this cool stuff ?
>>
>> log_line_prefix = '%m %a %u %p %c %m %v %x'

> The formatting cost only but it is so insignificant that does not
> worth bothering with it.

IIRC, %m would imply a gettimeofday call, which might be expensive
depending on your OS and hardware.  I think all the other info is
"just sitting around", though.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: How to raise index points when equal and like is used with gist ?
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: non-integer constant in ORDER BY: why exactly, and documentation?