>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
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