Re: Expensive log_line_prefix ? - Mailing list pgsql-general

From John R Pierce
Subject Re: Expensive log_line_prefix ?
Date
Msg-id 507742EE.9010504@hogranch.com
Whole thread Raw
In response to Re: Expensive log_line_prefix ?  (Sergey Konoplev <gray.ru@gmail.com>)
List 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 by date:

Previous
From: "Evan D. Hoffman"
Date:
Subject: Re: Disabling inferred "group by" columns in 9.1?
Next
From: Sergey Konoplev
Date:
Subject: Re: How to raise index points when equal and like is used with gist ?