this repo has no description
1# Connectivity
2max_connections = 200
3superuser_reserved_connections = 3
4listen_addresses='*'
5
6# Memory Settings
7shared_buffers = '4096 MB'
8work_mem = '32 MB'
9maintenance_work_mem = '420 MB'
10huge_pages = off
11effective_cache_size = '11 GB'
12effective_io_concurrency = 1 # concurrent IO only really activated if OS supports posix_fadvise function
13random_page_cost = 4 # speed of random disk access relative to sequential access (1.0)
14
15# Monitoring
16shared_preload_libraries = 'pg_stat_statements' # per statement resource usage stats
17track_io_timing=on # measure exact block IO times
18track_functions=pl # track execution times of pl-language procedures if any
19
20# Replication
21wal_level = replica # consider using at least 'replica'
22max_wal_senders = 10
23synchronous_commit = on
24
25# Checkpointing:
26checkpoint_timeout = '15 min'
27checkpoint_completion_target = 0.9
28max_wal_size = '1024 MB'
29min_wal_size = '512 MB'
30
31# WAL archiving
32archive_mode = on # having it on enables activating P.I.T.R. at a later time without restart›
33archive_command = '/bin/true' # not doing anything yet with WAL-s
34
35
36# WAL writing
37wal_compression = on
38wal_buffers = -1 # auto-tuned by Postgres till maximum of segment size (16MB by default)
39wal_writer_delay = 200ms
40wal_writer_flush_after = 1MB
41wal_keep_size = '3650 MB'
42
43
44# Background writer
45bgwriter_delay = 200ms
46bgwriter_lru_maxpages = 100
47bgwriter_lru_multiplier = 2.0
48bgwriter_flush_after = 0
49
50# Parallel queries:
51max_worker_processes = 8
52max_parallel_workers_per_gather = 4
53max_parallel_maintenance_workers = 4
54max_parallel_workers = 8
55parallel_leader_participation = on
56
57# Advanced features
58enable_partitionwise_join = on
59enable_partitionwise_aggregate = on
60jit = on
61max_slot_wal_keep_size = '1000 MB'
62track_wal_io_timing = on
63maintenance_io_concurrency = 1
64wal_recycle = on