[pgpool-hackers: 3283] New feature proposal: statement_level_load_balancing

[Bo Peng]

Hi All

Here is a patch for new feature "statement_level_load_balancing".
This feature enables selecting load balancing node per statement.

The current feature for load balancing, the load balancing node is decided 
at the session start time and will not be changed until the session ends. 

When set to statement_level_load_balancing = on, the load balancing node 
is decided for each read query.
 
For example, in applications that use connection pooling remain connections 
open to the backend server, because the session may be held for a long time, 
the load balancing node does not change until the session ends.
In such applications, when statement_level_load_balance is enabled, 
it is possible to decide load balancing node per query, not per session.

The default is off.

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: statement_level_load_balancing_v1.patch
Type: application/octet-stream
Size: 22499 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20190328/53d2cc65/attachment-0001.obj>