Skip to main content

PostgreSQL settings for 1C

PostgreSQL for 1C settings affect database cluster health and performance. When creating a cluster, the settings are set to default values. Default values are selected to ensure high cluster performance and differ depending on the cluster configuration and the version of PostgreSQL for 1C.

You can:

  • view the default setting values and change them when creating a cluster;
  • or view settings and edit them in an existing cluster.

We recommend changing setting values only when necessary—incorrect values can make the cluster inoperable or reduce its performance.

When scaling a cluster, the values of some settings are automatically replaced with default values. You can view the list of such settings in the Automatic settings change when scaling a cluster subsection.

View settings

You can view the list of settings available for modification when creating a cluster or editing settings.

If you have changed the settings, you can separately view a list of settings whose values differ from the default values.

For a detailed description of all settings, see the Server Configuration section of PostgreSQL documentation.

  1. In the control panel, in the top menu, click Products and select Cloud Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS settings block, click Edit.
  5. Optional: to view only settings where you changed the default value, select the Show changed parameters checkbox.
  6. View settings.

Change settings

carefully

We recommend changing setting values only when necessary—incorrect values can make the cluster inoperable or reduce its performance.

After changing some settings, the cluster will automatically reboot and will be unavailable during the reboot. The reboot will start immediately after saving the changes. You can view the list of such settings in the List of settings that require reboot subsection.

  1. In the control panel, in the top menu, click Products and select Cloud Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS settings block, click Edit.
  5. Specify new values.
  6. Click Save.

List of settings that require a restart

  • autovacuum_freeze_max_age;
  • autovacuum_max_workers;
  • autovacuum_multixact_freeze_max_age;
  • max_connections;
  • max_files_per_process;
  • max_locks_per_transaction;
  • max_logical_replication_workers;
  • max_pred_locks_per_transaction;
  • max_prepared_transactions;
  • max_wal_senders;
  • max_worker_processes;
  • old_snapshot_threshold;
  • pg_stat_statements.max;
  • shared_buffers;
  • track_activity_query_size.

Automatic setting changes when scaling a cluster

DBMS settings have limits of acceptable values. If, during cluster scaling, setting values fall outside the acceptable limits, such values are automatically replaced with default values so that the cluster can operate.

Once the cluster is scaled and switches to the ACTIVE status, you can edit the settings and set new values.

List of settings whose values are reset to defaults during cluster scaling:

  • autovacuum_max_workers;
  • effective_cache_size;
  • maintenance_work_mem;
  • max_parallel_workers;
  • max_worker_processes;
  • shared_buffers;
  • vacuum_cost_limit.