Re: Synchronization levels in SR - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Synchronization levels in SR
Date
Msg-id 22180.1283803883@sss.pgh.pa.us
Whole thread Raw
In response to Re: Synchronization levels in SR  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Synchronization levels in SR  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Mon, 2010-09-06 at 21:45 +0200, Boszormenyi Zoltan wrote:
>> The locks held by a transaction are released after
>> RecordTransactionCommit(), and waiting for the sync ack
>> happens in this function. Now what happens when a sync
>> transaction hold a lock that an async one is waiting for?

> It seems your glass in half-empty. Mine is half-full.

Simon, you really are failing to advance the conversation.  You claim
that we can have sync plus async transactions without a performance hit,
but you have failed to explain how, at least in any way that anyone
else understands.  Pontificating about how that will be so much better
than not having it doesn't address the problem that others are having
with seeing how to implement it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: 9.1alpha1 bundled -- please verify
Next
From: David Fetter
Date:
Subject: Re: git: uh-oh