Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 20F289F96DD for ; Mon, 13 Aug 2007 13:02:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 98291-02 for ; Mon, 13 Aug 2007 13:02:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id D57FD9F9A92 for ; Mon, 13 Aug 2007 13:02:45 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1IKcNN-0001J3-GR; Mon, 13 Aug 2007 17:02:41 +0100 To: "Joshua D. Drake" Cc: "Jonathan Ellis" , "smiley2211" , Subject: Re: How to ENABLE SQL capturing??? In-Reply-To: <46C07BFA.8000500@commandprompt.com> (Joshua D. Drake's message of "Mon\, 13 Aug 2007 08\:42\:50 -0700") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 1953) References: <12060736.post@talk.nabble.com> <20070808203612.GA26143@uio.no> <12096180.post@talk.nabble.com> <12099590.post@talk.nabble.com> <46BCDDAA.3060703@commandprompt.com> <46C07BFA.8000500@commandprompt.com> From: Gregory Stark Organization: EnterpriseDB Date: Mon, 13 Aug 2007 17:02:41 +0100 Message-ID: <87vebjqv6m.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/130 X-Sequence-Number: 26260 "Joshua D. Drake" 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