Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A0D299F9565 for ; Mon, 13 Aug 2007 12:40:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 74137-06 for ; Mon, 13 Aug 2007 12:40:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 65CAD9F958B for ; Mon, 13 Aug 2007 12:40:15 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7DFeFd3031793 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 13 Aug 2007 08:40:16 -0700 Message-ID: <46C07BFA.8000500@commandprompt.com> Date: Mon, 13 Aug 2007 08:42:50 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: Jonathan Ellis CC: smiley2211 , pgsql-performance@postgresql.org Subject: Re: How to ENABLE SQL capturing??? References: <12060736.post@talk.nabble.com> <20070808203612.GA26143@uio.no> <12096180.post@talk.nabble.com> <12099590.post@talk.nabble.com> <46BCDDAA.3060703@commandprompt.com> In-Reply-To: X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/3944/Sun Aug 12 23:12:09 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 13 Aug 2007 08:40:16 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/129 X-Sequence-Number: 26259 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jonathan Ellis wrote: > On 8/10/07, Joshua D. Drake wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> smiley2211 wrote: >>> Jeff, >>> >>> You are CORRECT...my queries were going to /var/log/messages...had to get >>> the Linux Admin to grant me READ access to the file... >> You may want to actually get that to stop. Syslog is a notorious >> performance bottleneck for postgresql. > > Can you elaborate? The only reference to this I could find was a > thread from 2004 where someone wasn't rotating his logs. I am not sure what to elaborate on :). Syslog is slow, logging to file isn't. Although both will certainly slow down your installation quite a bit, syslog will slow it down more. If I recall correctly, it is because syslog is blocking. Joshua D. Drake > > -Jonathan > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGwHv6ATb/zqfZUUQRAgMlAKCcZpj+CCP50Deo/CsSCN21IyjrCACghXfN uJQ+qsu4FI4Kjf8fpNiWgnw= =BJ8E -----END PGP SIGNATURE-----