Re: Expensive log_line_prefix ?

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