-
Notifications
You must be signed in to change notification settings - Fork 923
/
Copy pathpostgres.conf
36 lines (33 loc) · 849 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
30
31
32
33
34
35
36
max_connections = 300
fsync = off
synchronous_commit = off
full_page_writes = off
wal_level = minimal
max_wal_senders = 0
wal_sender_timeout = 0
row_security = off
wal_writer_delay = '10ms'
client_min_messages = error
autovacuum = false
checkpoint_completion_target = 0.9
log_min_duration_statement = '10s'
log_checkpoints = off
log_statement = 'none'
log_error_verbosity = terse
log_min_messages = panic
logging_collector = off
log_directory = '/dev/null'
log_min_error_statement = panic
client_min_messages = error
debug_pretty_print = off
max_connections = 50
shared_buffers = 70MB
effective_cache_size = 210MB
maintenance_work_mem = 17920kB
checkpoint_completion_target = 0.9
wal_buffers = 2150kB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 716kB
huge_pages = off