On 10/11/12 2:57 PM, Sergey Konoplev wrote:
On Thu, Oct 11, 2012 at 12:19 PM, Sahagian, David
<david.sahagian@xxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
