X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D97F5D1B83D for ; Wed, 3 Mar 2004 00:01:15 +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 97269-04 for ; Tue, 2 Mar 2004 20:01:12 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 67142D1B567 for ; Tue, 2 Mar 2004 20:01:09 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bob.samurai.com (Postfix) with ESMTP id 0354B1F01; Tue, 2 Mar 2004 19:01:12 -0500 (EST) Received: from bob.samurai.com ([127.0.0.1]) by localhost (bob.samurai.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 87750-01-10; Tue, 2 Mar 2004 19:01:11 -0500 (EST) Received: from samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by bob.samurai.com (Postfix) with ESMTP id DDB421F11; Tue, 2 Mar 2004 19:01:10 -0500 (EST) Message-ID: <40452047.6030501@samurai.com> Date: Tue, 02 Mar 2004 19:01:11 -0500 From: Neil Conway User-Agent: Mozilla Thunderbird 0.5 (X11/20040221) X-Accept-Language: en-us, en MIME-Version: 1.0 To: simon@2ndquadrant.com Cc: josh@agliodbs.com, 'Rob Fielding' , pgsql-performance@postgresql.org Subject: Re: WAL Optimisation - configuration and usage References: <004901c400a3$fb570570$5baa87d9@LaptopDellXP> In-Reply-To: <004901c400a3$fb570570$5baa87d9@LaptopDellXP> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/34 X-Sequence-Number: 5890 Simon Riggs wrote: >>Josh Berkus wrote >> >>>Simon Riggs wrote >>>Please set WAL_DEBUG to 1 so we can see a bit more info: thanks. >> >>I'm pretty sure that WAL_DEBUG requires a compile-time option. > > I'm surprised, but you are right, the manual does SAY this requires a > compile time option; it is unfortunately not correct. Actually, the manual is correct: in 7.4 and earlier releases, enabling wal_debug can be done without also setting a compile-time #ifdef. As of current CVS HEAD, the WAL_DEBUG #ifdef must be defined before this variable is available. -Neil