[Pgpool-general] Duration of commit on more than one backend configuration

[Tatsuo Ishii]

> As far as I know, pgpool-II waits for [all] backends to commit the SQL
> statements (under replication mode) before returning to the client,
> right? This means that if, for example, one of the backends is very busy
> (100% CPU, etc.), pgpool will experience a delay and so will the
> application. Is this correct?

Correct. This is a known behavior of all synchronous replication
systems. This ensures that committed data (from client's point of
view) is actually committed to all backends.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp