Fujii Masao írta: > On Wed, Sep 8, 2010 at 7:04 PM, Boszormenyi Zoltan <z...@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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers