Re: How to ENABLE SQL capturing???

"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