Pivotal Knowledge Base

Follow

How to change GPText Global Configuration Values

1. Set custom_variable_classes=gptext

gpconfig  -c custom_variable_classes -v 'gptext'
gpstop -u

2. Set gptext GUC in master's postgresql.conf and reload parameters.

Eg:

[gpadmin@mdw_vm gpseg-1]$ cat postgresql.conf|grep gptext.search_timeout
gptext.search_timeout=900

[gpadmin@mdw_vm gpseg-1]$ gpstop -u

3. Show the GPText global configuration values which you want to check:

Eg:

gpdb=# show gptext.search_timeout;
 gptext.search_timeout
-----------------------
 900


Comments

Powered by Zendesk