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.
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot