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

Поиск
Список
Период
Сортировка
От keshav upadhyaya
Тема What is the role of #fsync and #synchronous_commit in configuration file .
Дата
Msg-id d40c44910910060028k4d65f435h60a39e862a4e26ea@mail.gmail.com
обсуждение исходный текст
Ответы Re: What is the role of #fsync and #synchronous_commit in configuration file .  (Josh Kupershmidt <schmiddy@gmail.com>)
Список pgsql-novice
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   = on    and
 #synchronous_commit = on

They are commented by default in 8.4 .
When made like this :-
fsync = off             
synchronous_commit = off     


It improve the performance :)
and query took less time .

I want to understand more in details what exactly had happened  one is made them "off" , is it dangerous to do this ?  as it will not sync the data in each commit .

Pls help me out .

--
Thanks,
Keshav Upadhyaya

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql in bash - how to clear screen?
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: What is the role of #fsync and #synchronous_commit in configuration file .