Re: COMMIT NOWAIT Performance Option - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: COMMIT NOWAIT Performance Option
Date
Msg-id 200702272217.l1RMHjZ15874@momjian.us
Whole thread Raw
In response to Re: COMMIT NOWAIT Performance Option  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: COMMIT NOWAIT Performance Option  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Jonah H. Harris wrote:
> On 2/27/07, Josh Berkus <josh@agliodbs.com> wrote:
> > You're missing my point, which is that nobody has demonstrated that there
> > is any real performance gain from this.  I see no reason to implement it
> > if there is no performance gain.
> 
> While I'll back your request for results, it seems nearly impossible
> to expect no performance gain using this.
> 
> Results never hurt though.

The results are going to be very close to fsync off for sufficiently
high values delay, and we _know_ fsync off is a performance win.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: COMMIT NOWAIT Performance Option
Next
From: Bruce Momjian
Date:
Subject: Re: COMMIT NOWAIT Performance Option