Help Center/ GaussDB/ FAQs/ Database Parameter Modification/ How Do I Set the Maximum Number of WAL Sender Threads That Can Be Created in GaussDB?
Updated on 2024-09-13 GMT+08:00

How Do I Set the Maximum Number of WAL Sender Threads That Can Be Created in GaussDB?

WAL sender threads are occupied when standby DNs connect to primary DNs to obtain physical logs and when logical replication tools connect to primary DNs to obtain logical logs. On the GaussDB console, you can set the maximum number of WAL sender threads that can be created. Specifically, perform the following operations:

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters.
  6. Search for the max_wal_senders parameter in the search box.
  7. Change the parameter value and click Save. The value ranges from 8 to 100.
  8. In the displayed dialog box, click OK.
  • If this parameter is set to a value smaller than 20, scale-out may fail.
  • The value of this parameter must be smaller than that of max_connections.