<html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8"><style>body { line-height: 1.5; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div><span style="font-size: 10.5pt; line-height: 1.5; background-color: transparent;">Hi, Usama</span><span></span></div><div><div><br></div><div>I have made a new patch.</div><div>I make disable_load_balance_on_write to accept new value.</div><div>Set disable_load_balance_on_write = 'dml_load_balance' to enable this feature.</div><div><br></div><div>This new patch contains a test script in path ‘src/test/dml-load-balance-test’.</div><div>If pg installed by default in /usr/local/pgsql, just execute test.sh.</div><div>If pg is in other dir, execute ‘test.sh -p /path_to_pg_dir/’.</div><div>It will show “success: dml load balance test pass.” , when test pass.</div><div><br></div><div>this script will test below sql:</div><div><br></div><div>show pool_nodes;</div><div><br></div><div>-- test DML</div><div>begin ;</div><div>insert into tb_dml_insert values (1);</div><div>select * from tb_dml_insert ;</div><div>commit ;</div><div><br></div><div>begin ;</div><div>update tb_dml_update SET a = 2;</div><div>select * from tb_dml_update ;</div><div>commit ;</div><div><br></div><div>begin ;</div><div>delete from tb_dml_delete;</div><div>select * from tb_dml_delete;</div><div>commit ;</div><div><br></div><div>-- test trigger</div><div>begin ;</div><div>insert into tb_t1 values (1);</div><div>select * from tb_t2 ;</div><div>commit ;</div><div><br></div><div>-- test function</div><div>begin ;</div><div>select insert_tb_f_func(6);</div><div>select * from tb_f ;</div><div>commit ;</div><div><br></div><div>-- test view</div><div>begin ;</div><div>insert into tb_v values (8);</div><div>select * from tb_v_view ;</div><div>commit ;</div><div><br></div><div><br></div><div>Thanks</div><div>Best Regards</div></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div>sunbiao@highgo.com</div></div></span></div>
</body></html>