Configuring EDB Postgres Tuner

To run EDB Postgres Tuner, you need to add it to the shared_preload_libraries and create the extension in the database. EDB Postgres Tuner can then gather metrics to make tuning recommendations.

1. In the postgresql.conf file, add edb_pg_tuner to the shared_preload_libraries parameter:

   → WrapCopy

   shared_preload_libraries = 'edb_pg_tuner'

   Note

   If shared_preload_libraries has other extensions, then you can add edb_pg_tuner to the list. The order doesn't matter.

2. Restart Postgres.

3. Create the EDB Postgres Tuner extension in your database with the following command:

   → WrapCopy

   CREATE EXTENSION edb_pg_tuner;

Parameters

The following custom GUCs control the EDB Postgres Tuner extension behavior. If you modify these parameters, then reload Postgres to apply the changes.

• edb_pg_tuner.autotune — Applies tuning recommendations automatically. The default is false.

• edb_pg_tuner.naptime — Sets the interval between each check in seconds. The default is 600 seconds (10 minutes).

• edb_pg_tuner.max_wal_size_limit — Sets the maximum value for the max_wal_size recommendation. The default is 0, which sets no limit.