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 .
pgsql-novice by date
|Next:||From: Dave Dutcher||Date: 2009-10-06 12:49:37|
|Subject: Re: What is the role of #fsync and #synchronous_commit in configuration file .|
|Previous:||From: Tom Lane||Date: 2009-10-06 03:25:26|
|Subject: Re: psql in bash - how to clear screen? |
pgsql-performance by date
|Next:||From: Axel Rau||Date: 2009-10-06 10:26:53|
|Subject: Re: Best suiting OS|
|Previous:||From: Viji V Nair||Date: 2009-10-06 06:51:06|
|Subject: Re: Distributed/Parallel Computing|