X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D4927D1CCB9; Tue, 9 Mar 2004 21:34:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66719-07; Tue, 9 Mar 2004 17:34:48 -0400 (AST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id C9BACD1C96F; Tue, 9 Mar 2004 17:34:45 -0400 (AST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 1B0os9-0006D9-0X; Tue, 09 Mar 2004 21:34:46 +0000 Received: by mainbox.archonet.com (Postfix, from userid 529) id 9E99E17884; Tue, 9 Mar 2004 21:34:39 +0000 (GMT) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 578AA16E18; Tue, 9 Mar 2004 21:34:37 +0000 (GMT) From: Richard Huxton To: Greg Spiegelberg , PgSQL Performance ML , Postgres Admin List Subject: Re: [PERFORM] syslog slowing the database? Date: Tue, 9 Mar 2004 21:34:35 +0000 User-Agent: KMail/1.5 References: <404E2937.4060604@cranel.com> In-Reply-To: <404E2937.4060604@cranel.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403092134.35905.dev@archonet.com> X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/173 X-Sequence-Number: 12742 On Tuesday 09 March 2004 20:29, Greg Spiegelberg wrote: > iostat reported ~2000 blocks written every 2 > seconds to the DB file system. > > I turned syslog off to see if it was blocking anything and in the > past couple minutes 1GB has been restored and iostat reports ~35,000 > blocks written every 2 seconds to the DB file system. > Can anyone confirm this for me? If syslog is set to sync after every line and you're logging too much then it could slow things down as the disk heads shift back and fore between two areas of disk. How many disks do you have and in what configuration? Also - was PG logging a lot of info, or is some other application the culprit? Tip: put a minus "-" in front of the file-path in your syslog.conf and it won't sync to disk after every entry. -- Richard Huxton Archonet Ltd