Re: [PERFORM] What is the role of #fsync and #synchronous_commit in configuration file .

2009-10-06 Thread Dave Dutcher
>From: keshav upadhyaya >Subject: [PERFORM] What is the role of #fsync and #synchronous_commit in configuration file . > >Hi , >I want to imporve the performance for inserting of huge data in my table . >I have only one idex in table . > >First question - i want

[PERFORM] What is the role of #fsync and #synchronous_commit in configuration file .

2009-10-06 Thread keshav upadhyaya
Hi , I want to imporve the performance for inserting of huge data in my table . I have only one idex in table . First question - i want to know the role played by #fsync = onand #synchronous_commit = on They are commented by default in 8.4 . When made like this :- fsync = off synchronou