How To See The Value Of Guc?

1.	How To See The Value Of Guc?
Answer» By CONNECTING GPDB database USING psql query catalog or do show parameter. EXAMPLE: gpdb# select name,setting from pg_settings where name=’GUC’; or gpdb# show &LT;GUC_NAME>; By connecting GPDB database using psql query catalog or do show parameter. Example: gpdb# select name,setting from pg_settings where name=’GUC’; or gpdb# show <GUC_NAME>;

Answer»

By CONNECTING GPDB database USING psql query catalog or do show parameter.

gpdb# select name,setting from pg_settings where name=’GUC’;
or
gpdb# show &LT;GUC_NAME>;

By connecting GPDB database using psql query catalog or do show parameter.

Example:

gpdb# select name,setting from pg_settings where name=’GUC’;
or
gpdb# show <GUC_NAME>;

Discussion