On Mon, Mar 29, 2010 at 12:00 AM, Tadipathri Raghu <traghu.dba@xxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance