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 the `postgresql.conf` file which are :

 

        **edb_dynatune** :  edb_dynatune 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.

       **edb_dynatune_profile** :  The edb_dynatune_profile 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`.

**The following are parameters affected by Dynatune:**

       * `max_connections`
       * `work_mem`
       * `maintenance_work_mem`
       * `shared_buffers`
       * `max_fsm_relations`
       * `max_fsm_pages`
       * `wal_buffers`
       * `effective_cache_size`
       * `random_page_cost`
       * `checkpoint_segments`
       * `autovacuum_vacuum_threshold`
       * `autovacuum_vacuum_scale_factor`
       * `autovacuum_analyze_threshold`
       * `autovacuum_analyze_scale_factor`
       * `autovacuum_naptime`
       * `stats_row_level`
       * `autovacuum`

**Dynatune takes the following input:**
 
       * System Shared Memory `sys_shared_mem`
       * Current allocated Shared Buffers
       * Current MaxFSMRelations settings; 
       * Number of Buffers; 
       * Total Memory. 

**Dynatune sets the following parameters:**
 
       1. tune_max_connections 
       2. tune_work_mem; (Dynamically) 
       3. tune_maintenance_work_mem; (Dynamically) 
       4. tune_max_fsm_relations(); Required
       5. tune_max_fsm_pages(); 
       6. wal_buffers; 
       7. tune_shared_buffers(); Shared Buffer 
       8. tune_effective_cache_size (Dynamically) 
       9. random_page_cost; (Cost Based Parameters) 
      10.tune_checkpoint_segments; (WAL Parameters) 
      11.tune_autovacuum(percentage); (Autovacuum Parameters) 

By default, autovacuum is enabled in Advanced Server and Dynatune is responsible for tuning the autovacuum parameters. Dynatune does not enable autovacuum.
 
For more information about EDB Dynatune, please consult the EDB Dynatune documentation below :
 
 
 
Version history
Revision #:
4 of 4
Last update:
3 weeks ago
Updated by:
 
Labels (2)