gp_subtransaction_overflow

The gp_subtransaction_overflow module implements a SynxDB view and user-defined function for querying for backends experiencing subtransaction overflow; these are backends that have created more than 64 subtransactions, resulting in a high lookup cost for visibility checks.

The gp_subtransaction_overflow module is a SynxDB extension.

Installing and Registering the Module

The gp_subtransaction_overflow module is installed when you install SynxDB. Before you can use the view and user-defined function defined in the module, you must register the gp_subtransaction_overflow extension in each database where you want to use the function, using the following command:

CREATE EXTENSION gp_subtransaction_overflow;

For more information on how to use this module, see Monitoring a SynxDB System.