public inbox for [email protected]  
help / color / mirror / Atom feed
From: Josh Berkus <[email protected]>
To: [email protected]
Subject: Re: no universally correct setting for fsync
Date: Mon, 10 May 2010 17:23:10 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<A1EBC6E5100210B51612365E@amenophis>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>


> The real question is how much of a speed-up fsync provides compared to
> the same workload with synchronous_commit disabled.  The only case for
> fsync=off is one where that number is much faster.  

I can't say I've tested this.  Most of my head-to-heads on fsync were
before asych existed.

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com



view thread (35+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: no universally correct setting for fsync
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox