Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A3271633029 for ; Mon, 29 Mar 2010 03:45:55 -0300 (ADT) 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 79720-10 for ; Mon, 29 Mar 2010 06:45:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f200.google.com (mail-yw0-f200.google.com [209.85.211.200]) by mail.postgresql.org (Postfix) with ESMTP id 3187063271B for ; Mon, 29 Mar 2010 03:45:45 -0300 (ADT) Received: by ywh38 with SMTP id 38so5868174ywh.29 for ; Sun, 28 Mar 2010 23:45:44 -0700 (PDT) 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 :date:received:message-id:subject:from:to:cc:content-type; bh=NprxksPyqhXG9TSODjDYs5o7i1gpyouJJalRySwoIzI=; b=BbyH10a+so/2HiEmm6yQ81GuBNUgzMNanljqBhEa/qzjabd7jk0IOfaTgYb0Vf5fkh J029rV81T6Go3ieXKuxxJG7tW/n9JN2B2Dq8jfb5Z6UvFD/KGUl6DcxLpomX6PkoqnhR dlk1P6pzmF5sb3KtMV3K4z/htX6mx0lrNXOzY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=u0iDIfHHNxXBiJAn9n/5jpyArIRWSBm3U9ZvTdR8EZLfcjF5VoDglKuPYycStBwFA7 dASttzVwd9bkP3NJx7RS9vqz9e3zJsDQGdLchSFF+tva36lEDaoHDUnFXQSxV1im0LAV voBh1PXycJ4sQwb5srjwn0iQFmZhCSzv6l/Z0= MIME-Version: 1.0 Received: by 10.150.145.21 with HTTP; Sun, 28 Mar 2010 23:45:44 -0700 (PDT) In-Reply-To: <645d9d71003282300j6ef4a9d5pbfa257667e6a7e3a@mail.gmail.com> References: <645d9d71003250801o246439a0j93c7b568786e98de@mail.gmail.com> <3073cc9b1003251015x590e962ata59dadbb58b42ce5@mail.gmail.com> <645d9d71003252019u6f01a513x7876c1a97b448dea@mail.gmail.com> <645d9d71003282300j6ef4a9d5pbfa257667e6a7e3a@mail.gmail.com> Date: Mon, 29 Mar 2010 00:45:44 -0600 Received: by 10.150.250.42 with SMTP id x42mr1260348ybh.193.1269845144089; Sun, 28 Mar 2010 23:45:44 -0700 (PDT) Message-ID: Subject: Re: Why Wal_buffer is 64KB From: Scott Marlowe To: Tadipathri Raghu Cc: Pierre C , Jaime Casanova , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/365 X-Sequence-Number: 38190 On Mon, Mar 29, 2010 at 12:00 AM, Tadipathri Raghu wrote: > Hi All, > > Thank you for all the support. > > I have noticed one more thing here, that if you turn off the fsync and try > to run the transaction than its breaking the currnet filenode and generating > another filenode. Is it true that whenever you turn off or on the fsync the > filenode will break and create one more on that table.