MAX_RV_REMOTE_TRANSFER_MB Option
Limit the volume of RLV-enabled table data allowed to be transferred from the RLV store when a statement is executed on another node.
Any non-negative integer (in megabytes)
1000
Option can be set at the database (PUBLIC) or user level. At the database level, the value becomes the default for any new user, but has no impact on existing users. At the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.
Requires the SET ANY PUBLIC OPTION system privilege. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.
In a Multiplex, all access to RLV-enabled tables is performed on the RLV store node. Queries running on other nodes need to forward the fragment of the query involving RLV-enabled tables to the RLV store node to retrieve data. The MAX_RV_REMOTE_TRANSFER_MB option is the mechanism to accomplish this task. When a query plan estimate of the total volume of data to be transfered for all RLV-enabled tables within the query exceeds the limit set by this option, the query is rejected with an error before execution begins.
Set the Max_RV_Remote_Transfer_MB option to 0 to disable this RLV data transfer volume check. Queries exceeding this limit should be executed directly on the RLV store node.