Application Scenarios
To optimize the performance of your database instance, you can adjust the parameter items in the created parameter group according to the actual business scenario and requirements. Additionally, you can adjust the parameter items in the Parameter Settings of the List of Instances.
You can only modify custom-created parameter group templates. However, you cannot modify or edit the default parameter group templates.
² Note
• On the List of Instances page, select Instance Name/Instance ID. Then, select and jump to Parameter Settings to modify parameters. After changing and saving the dynamic parameters, the system immediately synchronizes the modified parameter values. After you modify the static parameters and save the modifications, the system will prompt whether to restart the instance immediately. When you click the Confirm button, the system restarts the instance and the parameter becomes valid. Or, you can click the Cancel button and the parameter becomes valid after you manually restart the database instance later. For the differences between dynamic parameters and static parameters, see Whether to restart column in the parameters.
• When you modify a user-defined parameter group on the Parameter Group Management interface, you need to perform the Apply operation to apply the modified parameter group to the database instance you specified. If the modified parameters include static parameters, you need to check Restart Instance on the application interface or manually restart the instance. The static parameters will become valid after the database instance is restarted.
Procedure
Method 1: Modifying the Current Instance Parameter
1. Log in to the eSurfing Cloud Portal.
2. Click Console and select the corresponding resource pool, such as East China 1.
3. Select RDS-PostgreSQL and click it to go to the Console Administration page.
4. On the List of Instances page, select the first column Instance Name/Instance ID in the first column of List of Instances and click the specified instance. Go to the page and select Parameter Settings.
5. On the Parameter List page, query the parameters you want to modify and follow the Modifiable Value Range prompt to modify the parameter values.
– Click Save and click OK in the pop-up box to save the modifications. If the modified parameters include static parameters, a prompt appears stating that some parameters can take effect only after restartup. Please select restarting according to the actual situation or manually restart the database instance later.
– Click Cancel to cancel this modification.
– Click Preview to preview the original and modified values of this modified parameter.
After the parameter modification is complete, you can click the View History Modifications button on the upper right side of the Parameter List to check the parameter modification records.
Method 2: Modifying the Custom Parameter Group Template and Apply it to an Instance
1. Log in to the eSurfing Cloud Portal.
2. Click Console and select the corresponding resource pool, such as East China 1.
3. Select RDS-PostgreSQL and click it to go to the Console Administration page.
4. Click Region in the upper left corner of the Console and select the corresponding region and product.
5. On the Parameter Group Management interface, select and click the name of the custom parameter group you want to modify and the Parameter List interface.
6. On the Parameter List interface, modify the corresponding parameter value according to your needs.
– Click Save and click OK in the pop-up box to save your modifications.
– Click Cancel to cancel this modification.
7. Modified parameter groups do not immediately take effect on your database instance. You need to execute the Apply operation and select the instance that needs the application.
8. This operation involves the modification of static parameters, which can take effect after restarting the instance.