Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 72617633029 for ; Mon, 29 Mar 2010 04:06:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 22570-10 for ; Mon, 29 Mar 2010 07:05:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id CA5066326AE for ; Mon, 29 Mar 2010 04:05:51 -0300 (ADT) Received: by vws8 with SMTP id 8so2364388vws.19 for ; Mon, 29 Mar 2010 00:05:50 -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=bDUop1/QoDdmT+zQYWPgDSxVHZ8THrQznfu5Ff7MRrQ=; b=B9VOEE8tEG58BwIMl20YtjkvzlBh/ZLwSI1Ngij3aaZ4SFHAKXBcUVwou3VXdoNafO Z8U3dY6+OnKgb7QQa73zYakfV8agYa+q6iLdo3elVpQXJVjXpdYrc8fF04HnpQULCCt5 QH28PcEf9GvMdaIcV7M1IZg1entXZFBpFvgf0= 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=XW0eDM16EpFw/FBap9a8YE0o7Afj9DUd1Lz+ZZLcYb6GxPChMP3MKTeFoZrHK4iDrC K2eYvRBAw4vWPu2vXZ/aIBHqPIPIUWutyCKjG4QP7NBlTY5ORYv01GhTkRrRhJHtMwb4 r6SBydLim0OflyKjWTEni1Fyn9Dy1gV1+tskQ= MIME-Version: 1.0 Received: by 10.220.99.197 with HTTP; Mon, 29 Mar 2010 00:05:50 -0700 (PDT) In-Reply-To: References: <645d9d71003250801o246439a0j93c7b568786e98de@mail.gmail.com> <3073cc9b1003251015x590e962ata59dadbb58b42ce5@mail.gmail.com> <645d9d71003252019u6f01a513x7876c1a97b448dea@mail.gmail.com> <645d9d71003282300j6ef4a9d5pbfa257667e6a7e3a@mail.gmail.com> Date: Mon, 29 Mar 2010 12:35:50 +0530 Received: by 10.220.126.222 with SMTP id d30mr2788597vcs.78.1269846350839; Mon, 29 Mar 2010 00:05:50 -0700 (PDT) Message-ID: <645d9d71003290005q2ba3b33fhca45d9e2f6067f3b@mail.gmail.com> Subject: Re: Why Wal_buffer is 64KB From: Tadipathri Raghu To: Scott Marlowe Cc: Pierre C , Jaime Casanova , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=0016e68f9f1ea940390482eb24ea X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.052 tagged_above=-10 required=5 tests=AWL=0.546, BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/366 X-Sequence-Number: 38191 --0016e68f9f1ea940390482eb24ea Content-Type: text/plain; charset=ISO-8859-1 Hi Scott, Yes, May i know any particular reason for behaving this. Are its looking for any consistency. I havnt got any clear picture here. Could you Please explain this.. Thanks & Regards Raghavendra On Mon, Mar 29, 2010 at 12:15 PM, Scott Marlowe wrote: > 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. > > From what I understand, with fsync on or off the same stuff gets > written. It's just not guaranteed to go out in the right order or > right now, but eventually. > --0016e68f9f1ea940390482eb24ea Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Scott,
=A0
Yes, May i know any particular reason for behaving this. Are its looki= ng for any consistency. I havnt got any clear picture here.
Could you Please explain this..
=A0
Thanks & Regards
Raghavendra

On Mon, Mar 29, 2010 at 12:15 PM, Scott Marlowe = <scott.marl= owe@gmail.com> wrote:
On Mon, Mar 29, 2010 at 12:00 AM, Tadipathri Raghu <traghu.dba@gmail.com> wrote:> Hi All,
>
> Thank you for all the support.
>
&g= t; I have noticed one more thing here, that if you turn off the fsync and t= ry
> to run the transaction than its breaking the currnet filenode and gene= rating
> another filenode. Is it true that whenever you turn off or o= n the fsync the
> filenode will break and create one more on that tab= le.

From what I understand, with fsync on or off the same stuff gets<= br>written. =A0It's just not guaranteed to go out in the right order or=
right now, but eventually.

--0016e68f9f1ea940390482eb24ea--