X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 868893AAF02 for ; Mon, 20 Dec 2004 23:09:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17562-07 for ; Mon, 20 Dec 2004 23:09:07 +0000 (GMT) Received: from mailhub2.une.edu.au (mailhub.une.edu.au [129.180.1.142]) by svr1.postgresql.org (Postfix) with ESMTP id BC57E3AAF75 for ; Mon, 20 Dec 2004 23:09:08 +0000 (GMT) Received: from icarus.une.edu.au (icarus.une.edu.au [129.180.47.120]) by mailhub2.une.edu.au (Postfix) with ESMTP id 752A47F29; Tue, 21 Dec 2004 10:09:06 +1100 (EST) Received: from [129.180.47.61] ([129.180.47.61]) by icarus.une.edu.au (8.12.8/8.12.8) with ESMTP id iBKN96T3012657; Tue, 21 Dec 2004 10:09:06 +1100 Message-ID: <41C75B92.7000807@abri.une.edu.au> Date: Tue, 21 Dec 2004 10:09:06 +1100 From: Alexander Borkowski Organization: Agricultural Business Research Institute User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Theo Galanakis Cc: "'pgsql-performance@postgresql.org'" Subject: Re: PG Logging is Slow References: <16C0CF355FA04944A69E5A4F5299D30B110EAC@ganesh.au.lpint.net> In-Reply-To: <16C0CF355FA04944A69E5A4F5299D30B110EAC@ganesh.au.lpint.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/253 X-Sequence-Number: 9628 Theo, > I tried the -/var/log/postgresql.log option however I noticed no > performance improvement. May be the fact that we use redhad linux and > syslog, I'm no sys-admin, so I'm not sure if there is a difference between > syslogd and syslog. Did you restart syslogd (that's the server process implementing the syslog (= system log) service) after you changed its configuration? In order to do so, try running /etc/init.d/syslog restart as root from a commandline. HTH Alex