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 326FFD1CA0D; Wed, 10 Mar 2004 16:54:09 +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 45231-10; Wed, 10 Mar 2004 12:53:58 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 320CAD1C98E; Wed, 10 Mar 2004 12:53:57 -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 i2AGrprE007689; Wed, 10 Mar 2004 11:53:51 -0500 (EST) To: Greg Spiegelberg Cc: PgSQL Performance ML , Postgres Admin List Subject: Re: syslog slowing the database? In-reply-to: <404F3996.2070105@cranel.com> References: <404E2937.4060604@cranel.com> <370.1078877805@sss.pgh.pa.us> <404F3996.2070105@cranel.com> Comments: In-reply-to Greg Spiegelberg message dated "Wed, 10 Mar 2004 10:51:50 -0500" Date: Wed, 10 Mar 2004 11:53:51 -0500 Message-ID: <7688.1078937631@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/188 X-Sequence-Number: 12757 Greg Spiegelberg writes: > If the log and database were on the same disk I'd be okay with the > current workaround. If the ``-'' gave me near the same performance as > turning syslog off I'd be okay with that too. However, neither of these > are the case so there has to be something else blocking between the two > processes. You could also consider not using syslog at all: let the postmaster output to its stderr, and pipe that into a log-rotation program. I believe some people use Apache's log rotator for this with good results. regards, tom lane