i am trying to enable pgpool load balancing on statement level but when i set
disable_load_balance_on_write = 'always'
and my session has any SET command to assign a session variable value load balancing is disabled.
After activating pgpool debugging it appeared that the once it sees a SET it is considering that the session is writable and hence forwarding it to primary.
is their any workaround on this situation.