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

On Tue, Oct 6, 2009 at 3:28 AM, keshav upadhyaya <ukeshav2009(at)gmail(dot)com> wrote:

> First question - i want to know the role played by
>
>  #fsync   = on    and
>  #synchronous_commit = on

These configurations are discussed here:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html

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

There's plenty of discussion in the documentation and the list
archives about the
risks of disabling fsync and/or synchronous commit. Here's one:
http://archives.postgresql.org/pgsql-performance/2006-04/msg00631.php

If you're struggling with performance issues, I'd post a detailed
description of
your problem and what you've tried so far to the -performance list, instead of
turning fsync off.

Josh