Re: Expensive log_line_prefix ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Expensive log_line_prefix ?
Date
Msg-id 1312.1349993880@sss.pgh.pa.us
Whole thread Raw
In response to Re: Expensive log_line_prefix ?  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Expensive log_line_prefix ?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List 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 by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: How to raise index points when equal and like is used with gist ?
Next
From: Ken Tanzer
Date:
Subject: Re: non-integer constant in ORDER BY: why exactly, and documentation?