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

2010-06-21 Thread Daniel . Crespo
Hi, 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.

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

2010-06-21 Thread 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

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

2010-06-21 Thread Ramon de Carvalho Valle
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: 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

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

2010-06-21 Thread Tatsuo Ishii
On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: 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

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

2010-06-21 Thread Ramon de Carvalho Valle
On 06/21/2010 10:16 PM, Tatsuo Ishii wrote: On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: 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

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

2010-06-21 Thread Tatsuo Ishii
On 06/21/2010 10:16 PM, Tatsuo Ishii wrote: On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: 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

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

2010-06-21 Thread Ramon de Carvalho Valle
On 06/21/2010 10:32 PM, Tatsuo Ishii wrote: On 06/21/2010 10:16 PM, Tatsuo Ishii wrote: On 06/21/2010 08:31 PM, Tatsuo Ishii wrote: 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