cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL Parameters Affected By EDB Dynatune

 

EnterpriseDB (EDB) Postgres Advanced Server supports dynamic tuning of the database server to make the optimal usage of the system resources available on the host machine on which it is installed.

 

The two parameters that control this functionality are located in thepostgresql.conffile which are:

 

        1.  edb_dynatune:  This parameter determines how much of the host system's resources are to be used by the

            database server based upon the host machine's total available resources and the intended usage of the host machine.


       2.  edb_dynatune_profile:  This parameter is used to control tuning aspects based upon
            the expected workload profile on the database server. This parameter takes effect upon
            startup of the database server. Possible values are"oltp", "reporting", "mixed".


  A.  The following are parameters affected by Dynatune { Note : This list is as of EDB AS 11, not all parameters are tuned in all configurations, and parameters set manually are not tuned}:
 
         1.  max_connections 
         2.  work_mem
         3.  maintenance_work_mem
         4.  shared_buffers
         5.  effective_cache_size
         6.  random_page_cost

 

B. Dynatune takes the following input:

 
       1.  System Shared Memory - "sys_shared_mem"
       2.  Current allocated Shared Buffers
       3.  Current MaxFSMRelations settings 
       4.  Number of Buffers
       5.  Total Memory 

 

 C. Dynatune sets the following parameters :

 
      1.  max_connections
      2.  work_mem
      3.  maintenance_work_mem
      4.  shared_bufferwal_buffers
      5.  effective_cache_size
      6.  random_page_cost
      7.  autovacuum_analyze_scale_factor
      8.  autovacuum_naptime
      9.  autovacuum

By default, autovacuum is enabled in Advanced Server and Dynatune is responsible for tuning the autovacuum parameters.
 
For more information about EDB Dynatune, please consult the EDB Dynatune documentation
 
 
Version history
Revision #:
16 of 16
Last update:
Tuesday
Updated by:
 
Labels (2)