Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CC1386336DF for ; Wed, 3 Mar 2010 13:32:28 -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 58949-06 for ; Wed, 3 Mar 2010 17:32:17 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f187.google.com (mail-iw0-f187.google.com [209.85.223.187]) by mail.postgresql.org (Postfix) with ESMTP id C99B3632E91 for ; Wed, 3 Mar 2010 13:32:16 -0400 (AST) Received: by iwn17 with SMTP id 17so1558702iwn.19 for ; Wed, 03 Mar 2010 09:32:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=h0+moECIxsRx/NYWoveSAbe+PB5t6eSbxwVjIIuhxd4=; b=oAD3VzShWY4nmv+ZB7FY3uf5r8sQGWNN7UDkVgh0Ka2lKUp54qjVlwSFR5z4uXJ0A7 Mw/WOESoiIuJVKg06I2W1brfolJ1MxO5ZfjQFdUo1iy1AqJm3/f8xtfILyrugECWYn7d QyHPs2+EINTkf1xqonqAC9IyCpBVbIkf7PGtY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=JTiw+2IbZzoFDk15Dhd1BoFeLLsTWzaFhQA8sf8iVpjI8Y/pTbgnfWi/fXe9j6jxSo hOsqq8qLtvx1biOrzv5GL3jDZ7v2Jp8cAH/t6z6332EIkfPoeivpg/IShdBH3LD/muyU Wv2HLrPyaXBXU+DK1YntK1AEgiYe+hEP15dSM= MIME-Version: 1.0 Received: by 10.231.85.198 with SMTP id p6mr906396ibl.65.1267637535718; Wed, 03 Mar 2010 09:32:15 -0800 (PST) Date: Wed, 3 Mar 2010 12:32:15 -0500 Message-ID: Subject: --with-wal-segsize in-effective? From: Dhimant Patel To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001485eaffaa053c860480e8dd2a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/32 X-Sequence-Number: 33831 --001485eaffaa053c860480e8dd2a Content-Type: text/plain; charset=ISO-8859-1 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.) During the compilation the configure script spitted out "checking for WAL segment size... 2MB" - so something was off - and I could not imagine what it is. After successful install and creating database, I still got 16MB files in my pg_xlog directory. That's too bad. I can not seem to be able to follow. I thought it time to turn on archive anyway. I got 16MB files in my archive location! So what am I doing wrong? Please help. -DP. --001485eaffaa053c860480e8dd2a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,

I am working with latest source downloaded from postgres org= site.
I compiled and installed the source with --with-wal-segsize=3D2, = assuming it should give me 4MB size xlog files. (As per the documentation i= t is a power of 2 value.)

During the compilation the configure script spitted out "checking = for WAL segment size... 2MB"=A0 - so something was off - and I could n= ot imagine what it is. After successful install and creating database, I st= ill got 16MB files in my pg_xlog directory. That's too bad. I can not s= eem to be able to follow.

I thought it time to turn on archive anyway. I got 16MB files in my arc= hive location!


So what am I doing wrong?

Please help.
=
-DP.
--001485eaffaa053c860480e8dd2a--