Configuring QHB for 1C

Example of settings in the QHB configuration:

WARNING!
You should take a responsible approach to the database configuration for various 1C packages. The configuration below is only an example and may differ from the configuration that you need. If you use a ready-made configuration from another system, it is impossible to guarantee that this configuration will work.

#------------------------------------------------------------------------------
# 1C SUPPORT PARAMETERS
#------------------------------------------------------------------------------
# Specially adjusted for 1C
# Designed for 8 core server
# RAM 64GB
#------------------------------------------------------------------------------
# Estimated number of users
max_connections = 525


# Memory
shared_buffers = 16GB 			
temp_buffers = 128MB 			


# Can be changed depending on the workload
work_mem = 256MB			
maintenance_work_mem = 256MB		
effective_cache_size = 48GB		


# WAL and related parameters
wal_level = minimal
max_wal_senders = 0
commit_delay = 1000
max_wal_size = 4GB
min_wal_size = 2GB
checkpoint_timeout = 15min


# Autovacuum parameters
autovacuum_max_workers = 4 		
vacuum_cost_limit = 400		 	
autovacuum_naptime = 20s
# For some heavy tables it is possible to customize
autovacuum_vacuum_scale_factor = 0.01
autovacuum_analyze_scale_factor = 0.025


# Section for setting up transactions, queries and plans
max_locks_per_transaction = 256
seq_page_cost = 1.0
random_page_cost = 2.5
from_collapse_limit = 8
join_collapse_limit = 8


huge_pages = off			
row_security = off


# Parameters related to OS interaction
max_files_per_process = 10000 		
max_parallel_maintenance_workers = 6
max_parallel_workers_per_gather = 0
synchronous_commit = off


# Special parameters
escape_string_warning = off
standard_conforming_strings = off
online_analyze.enable = on
plantuner.fix_empty_table = on
online_analyze.verbose = off
online_analyze.min_interval = 10000
online_analyze.capacity_threshold = 99999
online_analyze.table_type = 'temporary'                

WARNING!
For the 1C system, you need to set the maximum file size allowed for storage in the database to 495 MB.