Re: Synchronization levels in SR

Fujii Masao írta:
> On Wed, Sep 8, 2010 at 7:04 PM, Boszormenyi Zoltan <zb@cybertec.at> wrote:
>   
>> Then there is no use to implement individual sync/async
>> replicated transactions, period. An async replicated transaction
>> that waits for a sync replicated transaction because of locks
>> will become implicitely sync. It just waits for another transactions'
>> sync ack.
>>     
>
> Hmm.. it's the same with async transaction (i.e., synchronous_commit = false)
> and sync one (synchronous_commit = true). Async transaction cannot take the
> lock held by sync one until the sync has flushed the WAL.
>   

You are right.

-- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de    http://www.postgresql.at/