Re: How to ENABLE SQL capturing??? - Mailing list pgsql-performance

From Gregory Stark
Subject Re: How to ENABLE SQL capturing???
Date
Msg-id 87vebjqv6m.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
"Joshua D. Drake" <jd@commandprompt.com> writes:

> If I recall correctly, it is because syslog is blocking.

Are you sure it isn't just that syslog fsyncs its log files after every log
message? I don't think the individual syslogs are synchronous but if syslog
falls behind the buffer will fill and throttle the sender.

If your Postgres data is on the same device as the syslogs those fsyncs will
probably cause a big slowdown directly on Postgres's I/O as well.

You can turn off the fsyncs in syslog by putting a - before the filename.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How to ENABLE SQL capturing???
Next
From: "Joshua D. Drake"
Date:
Subject: Re: How to ENABLE SQL capturing???