cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL Parameters Affected By EDB Dynatune

Postgres Plus 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. These are:

 

edb_dynatuneedb_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.

Following are the parameters majorly used 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: 
 
1. System Shared Memorysys_shared_mem; 
2. Current allocated Shared Buffer 
3. Current MaxFSMRelations settings; 
4. Number of Buffers; 
5. Total Memory. 

And sets the following category of parameters: 
 
1. tune_max_connections 
2. tune_work_mem; (Dynamically) 
3. tune_maintenance_work_mem; (Dynamically) 
4. tune_max_fsm_relations();—Require 
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.
 
Refer the document here for detailed information on EDB Dynatune.
Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by:
 
Labels (2)
Contributors