[pgpool-hackers: 2726] Proposal: Disabling load balance after writing query
ishii at sraoss.co.jp
Fri Feb 16 11:42:27 JST 2018
Currently we have a feature to disable load balancing in a transaction
if write query is sent. This allows legacy applications that do not
consider streaming replication delay to be used with PostgreSQL's
streaming replication. However, if the transaction closes, in the
subsequent transaction load balancing starts again, which maybe not
good for read query because of the replication delay.
So my proposal is, adding a new configuration parameter called
"disable_load_balance_on_write" to allow more control on the existing
feature. Here are possible values for the configuration:
off: completely disable prohibiting load balance feature, including
transaction: same as current behavior, i.e. if write query is sent,
load balance is disabled within the transaction.
trans_transaction: the effect of "transaction" will continue in
the subsequent transactions.
always: the effect will continue even out side of transactions.
Comments and suggestions are welcome.
SRA OSS, Inc. Japan
More information about the pgpool-hackers