Skip to main content

PostgreSQL settings for 1C

Last update:

PostgreSQL for 1C settings affect the availability and performance of a database cluster. When creating a cluster, default values are set in the configuration. The default values are chosen to ensure high cluster performance and vary 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 change them in an already created 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 defaults. A list of such settings can be found in the Automatic settings change during cluster scaling subsection.

View settings

You can view the list of settings available for changes when creating a cluster or changing settings.

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

A detailed description of all settings can be found in the Server Configuration section of the PostgreSQL documentation.

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS Settings block, click Change.
  5. Optional: to view only those settings for which you have 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 certain settings, the cluster will automatically reboot and will be unavailable while it is rebooting. The reboot will start immediately after saving the changes. A list of such settings can be found in the List of settings that require a reboot subsection.

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the DBMS Settings block, click Change.
  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 valid value ranges. If, during cluster scaling, setting values exceed the valid ranges, these values are automatically replaced with default values so that the cluster can operate.

When the cluster is scaled and reaches the ACTIVE status, you can change 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.