AI Features
enable_hypo_index
Parameter description: Specifies whether the database optimizer considers the created virtual index when executing the EXPLAIN statement. By executing EXPLAIN on a specific query statement, you can evaluate whether the index can improve the execution efficiency of the query statement based on the execution plan provided by the optimizer.
This parameter is a USERSET parameter. Set it based on instructions provided in Table 1.
Value range: Boolean
- on indicates that a virtual index is created during EXPLAIN execution.
- off indicates that no virtual index is created during EXPLAIN execution.
Default value: off
db4ai_snapshot_mode
Parameter description: There are two snapshot modes: MSS (materialized mode, storing data entities) and CSS (computing mode, storing incremental information).
This parameter is a USERSET parameter. Set it based on instructions provided in Table 1.
Value range: a string, which can be MSS or CSS
- MSS indicates the materialized mode. The DB4AI stores data entities when snapshots are created.
- CSS indicates the computing mode. The DB4AI stores incremental information when creating snapshots.
Default value: MSS
db4ai_snapshot_version_delimiter
Parameter description: Specifies the delimiter for the snapshot version of a data table.
This parameter is a USERSET parameter. Set it based on instructions provided in Table 1.
Value range: a string, consisting of one or more characters.
Default value: @
db4ai_snapshot_version_separator
Parameter description: Specifies the subversion delimiter of a data table snapshot.
This parameter is a USERSET parameter. Set it based on instructions provided in Table 1.
Value range: a string, consisting of one or more characters.
Default value: .
unix_socket_directory
Parameter description: Specifies the path for storing files in the unix_socket communication mode. You can set this parameter only in the configuration file postgresql.conf. Before enabling the fenced mode, you need to set this GUC parameter.
This parameter is a POSTMASTER parameter. Set it based on instructions provided in Table 1.
Value range: a string of 0 or more characters
Default value: ''