Global Temporary Table

max_active_global_temporary_table

Parameter description: Specifies whether global temporary tables can be created.

This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1 GUC parameters.

Value range: an integer ranging from 0 to 1000000

• 0: The global temporary table function is disabled.
• > 0: The global temporary table function is enabled.

Default value: 1000

vacuum_gtt_defer_check_age

Parameter description: Checks the differences between the global temporary table relfrozenxid and the ordinary table after VACUUM is executed. WARNING is generated if the difference value exceeds the specified parameter value. Use the default value for this parameter.

This parameter is a USERSET parameter. Set it based on instructions provided in Table 1 GUC parameters.

Value range: an integer ranging from 0 to 1000000

Default value: 10000

enable_gtt_concurrent_truncate

Parameter description: Whether concurrent execution of global temporary table truncate table and DML is supported, and concurrent execution of global temporary table truncate table and truncate table.

This parameter is a SIGHUP parameter. Set it based on instructions provided in Table 1 GUC parameters.

Value range: Boolean

• on/true means the above operations are supported.
• off/false means that the above operations are not supported.

Default value: on