Re: Expensive log_line_prefix ?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Expensive log_line_prefix ?
Дата
Msg-id 507742EE.9010504@hogranch.com
обсуждение исходный текст
Ответ на Re: Expensive log_line_prefix ?  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-general
On 10/11/12 2:57 PM, Sergey Konoplev wrote:
> 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.

i'd think the time spent writing the extra output to the log file would
be the most significant part of it, along with any disk IO contention if
those logs are on the same physical storage as the database.





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



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

Предыдущее
От: "Evan D. Hoffman"
Дата:
Сообщение: Re: Disabling inferred "group by" columns in 9.1?
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: How to raise index points when equal and like is used with gist ?