vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0884.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

4.5 KiB
Raw Permalink Blame History

Viewing GUC Parameters

GaussDB(DWS) GUC parameters can control database system behaviors. You can check and adjust the GUC parameters based on your business scenario and data volume.

  • After a cluster is installed, you can check common database parameters on the GaussDB(DWS) management console.

  • You can also connect to a cluster and run SQL commands to check the GUC parameters.
    • Run the SHOW command.
      To view a certain parameter, run the following command:
      1
      SHOW server_version;

      server_version indicates the database version.

      Run the following command to view all the parameters:
      1
      SHOW ALL;
    • Use the pg_settings view.
      To view a certain parameter, run the following command:
      1
      SELECT * FROM pg_settings WHERE NAME='server_version';
      Run the following command to view values of all parameters:
      1
      SELECT * FROM pg_settings;
Parent topic: GUC Parameters