-
-
Notifications
You must be signed in to change notification settings - Fork 2
/
postgres.conf
29 lines (26 loc) · 657 Bytes
/
postgres.conf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
listen_addresses = '*'
# DB Version: 12
# OS Type: linux
# DB Type: mixed
# Total Memory (RAM): 2 GB
# CPUs num: 2
# Connections num: 20
# Data Storage: ssd
max_connections = 100
shared_buffers = 512MB
effective_cache_size = 1536MB
maintenance_work_mem = 128MB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 13107kB
min_wal_size = 1GB
max_wal_size = 4GB
# max_worker_processes = 2
# max_parallel_workers_per_gather = 1
# max_parallel_workers = 2
# max_parallel_maintenance_workers = 1
# timescaledb extension
shared_preload_libraries = 'timescaledb'