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

From A.M.
Subject Re: COMMIT NOWAIT Performance Option
Date
Msg-id 6155E1B9-FBA9-4B47-90B6-D37BADD08947@themactionfaction.com
Whole thread Raw
In response to Re: COMMIT NOWAIT Performance Option  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: COMMIT NOWAIT Performance Option
List pgsql-hackers
On Feb 26, 2007, at 18:58 , Simon Riggs wrote:

> On Mon, 2007-02-26 at 23:25 +0000, Richard Huxton wrote:
>> Simon Riggs wrote:
>>> Proposal: Implement a new option for COMMIT, for enhancing  
>>> performance,
>>> providing a MySQL-like trade-off between performance and  
>>> robustness for
>>> *only* those that want it.
>>>
>>>         COMMIT NOWAIT

Isn't the domain of transient data relegated to certain tables  
instead of specific transactions? Wouldn't it be easier to create un- 
wal-logged global temp tables?

-M


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: COMMIT NOWAIT Performance Option
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Load distributed checkpoint