Updated on 2024-05-07 GMT+08:00

Other Default Parameters

This section describes the default database loading parameters.

dynamic_library_path

Parameter description: Specifies the path that the system will search for a shared database file that is dynamically loadable. When a dynamically loadable 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. Only the sysadmin user can access this parameter.

The value of dynamic_library_path must be a list of absolute paths separated by colons (:) or by semi-colons (;) on the Windows OS. When the name of a path starts with the special variable $libdir, the variable will be replaced with the directory in which the module provided by the GaussDB is installed. For example:
1
dynamic_library_path = '/usr/local/lib/postgresql:/opt/testgs/lib:$libdir'

This is a SUSET parameter. Set it based on instructions provided in Table 1.

Value range: a string

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.

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

Value range: an integer ranging from 0 to 2147483647

Default value: 0

local_preload_libraries

Parameter description: Specifies one or more shared libraries that are to be preloaded at connection start. If multiple libraries are to be loaded, separate their names with commas (,). All library names are converted to lower case unless double-quoted.

  • Any user can change this option. Therefore, library files that can be loaded are restricted to those saved in the plugins subdirectory of the standard library installation directory. It is the database administrator's responsibility to ensure that libraries in this directory are all safe. Entries in local_preload_libraries can specify the library directory explicitly, for example, $libdir/plugins/mylib, or just specify the library name, for example, mylib. (mylib is equivalent to $libdir/plugins/mylib.)
  • Unlike shared_preload_libraries, there are no differences in performance between loading a module at session start or doing this during the session. The intent of this feature is to allow debugging or performance-measurement libraries to be loaded into specific sessions without an explicit LOAD command. For example, debugging can be enabled under a given user name by setting this parameter to ALTER USER SET.
  • If a specified library is not found, the connection attempt will fail.
  • Every GaussDB-supported library has a "magic block" that is checked to guarantee compatibility. For this reason, non-GaussDB-supported libraries cannot be loaded in this way.

This parameter is a BACKEND parameter. Set it based on instructions provided in Table 1.

Value range: a string

Default value: empty