[pgpool-general: 1499] Re: Load balancing changes between 2.x and 3.x

[Joshua D. Drake]

On 03/14/2013 03:54 PM, Tatsuo Ishii wrote:
>
>> Are there behavior changes in how pgpool decides to load balance
>> queries between version 2.x and 3.x?
>
> Yes. Main difference is, 3.x does more load balance when operated in
> streaming replication mode. For example, even if you in an explicit
> transaction block, pgpool allows to load balance SELECTs.

So using:

BEGIN;
SELECT
COMMIT;

In 2.x will not be load balanced but in 3 it will?

Sincerely,

Joshua D. Drake


-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579