How to modify parameters
Updated at:
Copy as MD
AnalyticDB for PostgreSQL supports parameter configuration at different scopes:
| Scope | Method | Effect |
|---|---|---|
| User level | ALTER ROLE <username> SET <parameter_name> = <value> | Takes effect only on the specified user |
| Instance level | Submit a ticket or join the DingTalk support group | Managed by Alibaba Cloud |
Set a user-level parameter
Run the following statement to set a parameter for a specific user:
ALTER ROLE <username> SET <parameter_name> = <value>;This statement only takes effect on the specified user.
For the full list of configurable parameters, see the Greenplum documentation.
Modify instance-level parameters
Instance-level parameters are managed by Alibaba Cloud. To request a change, submit a ticket or join the AnalyticDB for PostgreSQL technical support group on DingTalk. For contact information, see How do I obtain technical details about AnalyticDB for PostgreSQL?
Is this page helpful?