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

From Josh Berkus
Subject Re: COMMIT NOWAIT Performance Option
Date
Msg-id 200702271156.17375.josh@agliodbs.com
Whole thread Raw
In response to Re: COMMIT NOWAIT Performance Option  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: COMMIT NOWAIT Performance Option  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
Jonah,

> Under Oracle, NOWAIT is an asynchronous commit... anyone that uses it
> should understand that it's still not on-disk and that they can lose
> it in the event of a failure.  That's what Oracle's docs even say.
> It's just a risk vs. reward trade off.

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.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: COMMIT NOWAIT Performance Option
Next
From: "Joshua D. Drake"
Date:
Subject: Re: COMMIT NOWAIT Performance Option