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 E8CD0D1C4EB; Wed, 10 Mar 2004 00:16:50 +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 13399-02; Tue, 9 Mar 2004 20:16:51 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 4CE2ED1BA93; Tue, 9 Mar 2004 20:16:48 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2A0GjpK000371; Tue, 9 Mar 2004 19:16:46 -0500 (EST) To: Greg Spiegelberg Cc: PgSQL Performance ML , Postgres Admin List Subject: Re: syslog slowing the database? In-reply-to: <404E2937.4060604@cranel.com> References: <404E2937.4060604@cranel.com> Comments: In-reply-to Greg Spiegelberg message dated "Tue, 09 Mar 2004 15:29:43 -0500" Date: Tue, 09 Mar 2004 19:16:45 -0500 Message-ID: <370.1078877805@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/168 X-Sequence-Number: 12737 Greg Spiegelberg writes: > I turned syslog back on and the restore slowed down again. Turned > it off and it sped right back up. We have heard reports before of syslog being quite slow. What platform are you on exactly? Does Richard's suggestion of turning off syslog's fsync help? regards, tom lane