Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B491A632B8A for ; Wed, 3 Mar 2010 19:31:50 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20439-08 for ; Wed, 3 Mar 2010 23:31:40 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 3308F6326D7 for ; Wed, 3 Mar 2010 19:31:40 -0400 (AST) Received: by gyd8 with SMTP id 8so54948gyd.19 for ; Wed, 03 Mar 2010 15:31:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type; bh=2v7OlEyhRX4cMKrLY9v2X+q9iF6DhC2LxymYFwDWrOE=; b=khPB3hwwAIfkUhoDcr2PIXsX4FvRflOr1NwNwKdxKc9suLTQqMOkIzUGTmVm9pu++2 D24dMOQ79SWeZv4ii/xSQLFu7+biyVCXGbr1CJbnXNnFlmZLS1zwwYQLPEQGdtl6Yjss iYE0aoK7stuhy/NPO2/f8YraPjI6pq7WMCD4k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=TJ6ZmTMFAjG0ivLktFGoB9dw3bcVeY0JczxHYshCWeJUNDjQ69v4CGhyyPiPep2bEZ fRTpu5HXml/yuklLtCb2eTFNLxkC3Y6yJ+miLZK7OAj0SnmESRjxyQfrZLClfhtb39jg ZQsz5+1FBVzJuxnY+/XCVHvNLCrT00+3erv6g= MIME-Version: 1.0 Received: by 10.90.42.18 with SMTP id p18mr2796284agp.88.1267659098589; Wed, 03 Mar 2010 15:31:38 -0800 (PST) In-Reply-To: References: From: Alex Hunsaker Date: Wed, 3 Mar 2010 16:31:17 -0700 Message-ID: <34d269d41003031531v1e126502vee39d5cb2ae54092@mail.gmail.com> Subject: Re: --with-wal-segsize in-effective? To: Dhimant Patel Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201003/36 X-Sequence-Number: 33835 On Wed, Mar 3, 2010 at 10:32, Dhimant Patel wrote: > Hi All, > > I am working with latest source downloaded from postgres org site. > I compiled and installed the source with --with-wal-segsize=2, assuming it > should give me 4MB size xlog files. (As per the documentation it is a power > of 2 value.) Erm "it must be a power of 2" not "It will times it by 2"... So 2 being a power of 2 should give you 2MB. It should fail with say 3MB or any non power of 2 number.