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 ABF3BD1D1B2; Wed, 10 Mar 2004 01:33:03 +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 33250-10; Tue, 9 Mar 2004 21:33:00 -0400 (AST) Received: from rockhopper (CPE-144-132-200-73.nsw.bigpond.net.au [144.132.200.73]) by svr1.postgresql.org (Postfix) with ESMTP id 3D1F6D1CCB9; Tue, 9 Mar 2004 21:32:54 -0400 (AST) Received: from [192.168.5.2] (chinstrap [192.168.5.2]) by rockhopper (8.11.6/8.11.2) with ESMTP id i2A1WCH12856; Wed, 10 Mar 2004 12:32:12 +1100 Subject: Re: [PERFORM] syslog slowing the database? From: Stephen Robert Norris To: "Gavin M. Roy" Cc: PgSQL Performance ML , Postgres Admin List In-Reply-To: <404E6AB9.4030404@ehpg.net> References: <404E2937.4060604@cranel.com> <370.1078877805@sss.pgh.pa.us> <404E6AB9.4030404@ehpg.net> Content-Type: text/plain Organization: CommSecure Australia Pty Ltd Message-Id: <1078882327.9858.24.camel@chinstrap> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Wed, 10 Mar 2004 12:32:07 +1100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/176 X-Sequence-Number: 12745 On Wed, 2004-03-10 at 12:09, Gavin M. Roy wrote: > Might want to look at metalog, it does delayed writes, though ultimately > your issue is io bound and there's not much you can do to reduce io if > you want to keep syslog logging your pgsql queries and such. Yeah, but syslog with fsync() after each line is much, much worse than syslog without it, assuming anything else is on the same disk (array). It just guarantees to screw up your drive head movements... -- Stephen Norris srn@fn.com.au Farrow Norris Pty Ltd +61 417 243 239