| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Expensive log_line_prefix ? |
| Date: | 2012-10-11 22:06:38 |
| Message-ID: | 507742EE.9010504@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/11/12 2:57 PM, Sergey Konoplev wrote:
> On Thu, Oct 11, 2012 at 12:19 PM, Sahagian, David
> <david(dot)sahagian(at)emc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2012-10-11 22:14:30 | Re: How to raise index points when equal and like is used with gist ? |
| Previous Message | Sergey Konoplev | 2012-10-11 21:57:24 | Re: Expensive log_line_prefix ? |