listen_addresses = '*'		# what IP address(es) to listen on;
max_connections =4200			# (change requires restart)
ssl = on
ssl_cert_file = 'server.crt'
ssl_key_file = 'server.key'
shared_buffers = 8GB			# min 128kB
temp_buffers = 128MB			# min 800kB
work_mem = 256MB				# min 64kB
maintenance_work_mem = 16GB		# min 1MB
autovacuum_work_mem = 4GB		# min 1MB, or -1 to use maintenance_work_mem
max_stack_depth = 2MB			# min 100kB
dynamic_shared_memory_type = posix	# the default is the first option
effective_io_concurrency = 4		# 1-1000; 0 disables prefetching
max_worker_processes = 16		# (change requires restart)
max_parallel_workers_per_gather = 16	# taken from max_parallel_workers
max_parallel_workers = 16		# maximum number of max_worker_processes that
fsync = on				# flush data to disk for crash safety
synchronous_commit = off		# synchronization level;
full_page_writes = off			# recover from partial page writes
checkpoint_timeout = 10min		# range 30s-1d
max_wal_size = 2GB
checkpoint_completion_target = 0.9	# checkpoint target duration, 0.0 - 1.0
random_page_cost = 2.5			# same scale as above
effective_cache_size = 20GB
geqo_threshold = 20
default_statistics_target = 5000
constraint_exclusion = on	# on, off, or partition
log_destination = 'stderr'		# Valid values are combinations of
log_directory = '/var/docker/log/postgresql'		# directory where log files are written,
log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h'			# special values:
log_timezone = 'Europe/Paris'
track_activity_query_size = 8192	# (change requires restart)
autovacuum = on			# Enable autovacuum subprocess?  'on'
datestyle = 'iso, dmy'
timezone = 'Europe/Paris'
lc_messages = 'C'			# locale for system error message
lc_monetary = 'fr_FR.UTF-8'			# locale for monetary formatting
lc_numeric = 'fr_FR.UTF-8'			# locale for number formatting
lc_time = 'fr_FR.UTF-8'				# locale for time formatting
default_text_search_config = 'pg_catalog.french'
deadlock_timeout = 5s
max_locks_per_transaction = 128		# min 10
escape_string_warning = off