Skip site navigation (1) Skip section navigation (2)

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

From: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: What is the role of #fsync and #synchronous_commit in configuration file .
Date: 2009-10-06 07:28:01
Message-ID: d40c44910910060028k4d65f435h60a39e862a4e26ea@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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

Responses

pgsql-novice by date

Next:From: Dave DutcherDate: 2009-10-06 12:49:37
Subject: Re: What is the role of #fsync and #synchronous_commit in configuration file .
Previous:From: Tom LaneDate: 2009-10-06 03:25:26
Subject: Re: psql in bash - how to clear screen?

pgsql-performance by date

Next:From: Axel RauDate: 2009-10-06 10:26:53
Subject: Re: Best suiting OS
Previous:From: Viji V NairDate: 2009-10-06 06:51:06
Subject: Re: Distributed/Parallel Computing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group