> When inserting, updating or deleting through pgpool connected to two > backends, is the order of commits: > > > > 1. Backend 0, and then Backend 1?
Actually Backend 1, and then Backend 0. > 2. "at the same time" (in two independent threads) and waits for both > to be successful in order to return a successful transaction to the > client? > > > > If the answer is 1, why not 2? To avoid "global" deadlock. If there's only one session, global deadlock will never occur and we could do as you suggested. This will be a nice optimization but we do not do so currently. -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
