Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E66E7650858 for ; Wed, 9 Jul 2008 09:51:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29209-04 for ; Wed, 9 Jul 2008 09:50:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from panix.internal.net (cpe-77-83-163-186-dsl.netone.gr [77.83.163.186]) by postgresql.org (Postfix) with ESMTP id C7A4965088E for ; Wed, 9 Jul 2008 09:50:55 -0300 (ADT) Received: from panix.internal.net (localhost [127.0.0.1]) by panix.internal.net (8.14.2/8.14.2) with ESMTP id m69CpWQs069028; Wed, 9 Jul 2008 15:51:32 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by panix.internal.net (8.14.2/8.14.2/Submit) id m69CpVX4069027; Wed, 9 Jul 2008 15:51:31 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: panix.internal.net: achix set sender to achill@matrix.gatewaynet.com using -f From: "achill@matrix" To: david@lang.hm Subject: Re: syslog performance when logging big statements User-Agent: KMail/1.9.7 Cc: Tom Lane , Jeff , pgsql-performance@postgresql.org References: <200807081524.47366.achill@matrix.gatewaynet.com> <16218.1215553157@sss.pgh.pa.us> In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Date: Wed, 9 Jul 2008 15:51:30 +0300 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200807091551.31404.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200807/82 X-Sequence-Number: 30682 >In FreeBSD 7.0 by default it does not fsync (except for kernel messages), >unless the path is prefixed by "-" whereas it syncs. Sorry, scrap the above sentence. The correct is to say that FreeBSD 7.0 by default it does not fsync(2) (except for kernel messages), and even in this case of kernel messages, syncing can be bypassed by the use of "-" prefix. So in our case of postgresql (local0 facility) it does not sync.