Vertica Analytics Platform Version 9.2.x Documentation

RESET_LOAD_BALANCE_POLICY

Resets the counter each host in the cluster maintains, to track which host it will refer a client to when the native connection load balancing scheme is set to ROUNDROBIN. To reset the counter, run this function on all cluster nodes.

Syntax

RESET_LOAD_BALANCE_POLICY()   

Privileges

Superuser

Example

=> SELECT RESET_LOAD_BALANCE_POLICY();
                        RESET_LOAD_BALANCE_POLICY
-------------------------------------------------------------------------
Successfully reset stateful client load balance policies: "roundrobin".
(1 row)