---
title: "PostgreSQL settings for 1C"
sidebar_label: "Settings"
sidebar_position: 4
description: "How to change PostgreSQL settings for 1C"
---

import Formbricks from '@theme/MDXComponents/Formbricks'
import Settings from '@site/i18n/en/docusaurus-plugin-content-docs/current/_partials/managed-databases/postgresql/settings.mdx'
import HugePagesSetting from '@site/i18n/en/docusaurus-plugin-content-docs/current/_partials/managed-databases/postgresql/huge-pages-setting.mdx'

# PostgreSQL settings for 1C

<Settings DatabaseName="PostgreSQL for 1C" slug="postgresql-for-1c" />

### List of settings that require a restart \{#list-of-settings-that-require-reboot}

* `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 \{#automatically-changed-settings-after-scaling-up-cluster}

DBMS settings have valid value ranges. If, during [cluster scaling](/managed-databases/postgresql-for-1c/resize-cluster.mdx), 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](#change-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.`

<Formbricks />