Other Default Parameters¶
This section describes the default database loading parameters of the database system.
dynamic_library_path¶
Parameter description: Specifies the path for saving the shared database files that are dynamically loaded for data searching. When a dynamically loaded module needs to be opened and the file name specified in the CREATE FUNCTION or LOAD command does not have a directory component, the system will search this path for the required file.
The value of dynamic_library_path must be a list of absolute paths separated by colons (:) or by semi-colons (;) on the Windows OS. The special variable $libdir in the beginning of a path will be replaced with the module installation directory provided by GaussDB(DWS). Example:
dynamic_library_path = '/usr/local/lib/postgresql:/opt/testgs/lib:$libdir'
Type: SUSET
Value range: a string
Note
If the value of this parameter is set to an empty character string, the automatic path search is turned off.
Default value: $libdir
gin_fuzzy_search_limit¶
Parameter description: Specifies the upper limit of the size of the set returned by GIN indexes.
Type: USERSET
Value range: an integer ranging from 0 to INT_MAX. The value 0 indicates no limit.
Default value: 0