Tune PostgreSQL settings

You need to tune the PostgreSQL configuration for optimal performance with Swarm64 DA.

The server configuration is highly dependent on the workload and the available hardware.

  1. Connect to the database: 
    psql
  2. Locate your postgresql.conf file by executing: 
    SHOW config_file;
  3. Tune the settings in your postgresql.conf.
    Consult the settings list in Recommended PostgreSQL settings and adapt them to your workload and system in your configuration file.
  4. Restart PostgreSQL.