|
69 | 69 |
|
70 | 70 | # - Security & Authentication - |
71 | 71 |
|
72 | | -#authentication_timeout =60#1-600, in seconds |
| 72 | +#authentication_timeout =1min#1s-600s |
73 | 73 | #ssl = off# (change requires restart) |
74 | 74 | #password_encryption = on |
75 | 75 | #db_user_namespace = off |
|
98 | 98 |
|
99 | 99 | # - Memory - |
100 | 100 |
|
101 | | -#shared_buffers = 32000kB# min16 or max_connections*2, 8kB each |
| 101 | +#shared_buffers = 32000kB# min128kB or max_connections*16kB |
102 | 102 | # (change requires restart) |
103 | | -#temp_buffers =1000# min100, 8kB each |
| 103 | +#temp_buffers =8000kB# min800kB |
104 | 104 | #max_prepared_transactions = 5# can be 0 or more |
105 | 105 | # (change requires restart) |
106 | 106 | # Note: increasing max_prepared_transactions costs ~600 bytes of shared memory |
107 | 107 | # per transaction slot, plus lock space (see max_locks_per_transaction). |
108 | | -#work_mem =1024# min64, size in kB |
109 | | -#maintenance_work_mem =16384# min1024, size in kB |
110 | | -#max_stack_depth =2048# min100, size in kB |
| 108 | +#work_mem =1MB# min64kB |
| 109 | +#maintenance_work_mem =16MB# min1MB |
| 110 | +#max_stack_depth =2MB# min100kB |
111 | 111 |
|
112 | 112 | # - Free Space Map - |
113 | 113 |
|
|
132 | 132 |
|
133 | 133 | # - Background writer - |
134 | 134 |
|
135 | | -#bgwriter_delay =200# 10-10000 milliseconds between rounds |
| 135 | +#bgwriter_delay =200ms# 10-10000ms between rounds |
136 | 136 | #bgwriter_lru_percent = 1.0# 0-100% of LRU buffers scanned/round |
137 | 137 | #bgwriter_lru_maxpages = 5# 0-1000 buffers max written/round |
138 | 138 | #bgwriter_all_percent = 0.333# 0-100% of all buffers scanned/round |
|
162 | 162 | # - Checkpoints - |
163 | 163 |
|
164 | 164 | #checkpoint_segments = 3# in logfile segments, min 1, 16MB each |
165 | | -#checkpoint_timeout =300# range30-3600, in seconds |
166 | | -#checkpoint_warning =30# in seconds, 0 is off |
| 165 | +#checkpoint_timeout =5min# range30s-1h |
| 166 | +#checkpoint_warning =30s# 0 is off |
167 | 167 |
|
168 | 168 | # - Archiving - |
169 | 169 |
|
|
195 | 195 | #cpu_tuple_cost = 0.01# same scale as above |
196 | 196 | #cpu_index_tuple_cost = 0.005# same scale as above |
197 | 197 | #cpu_operator_cost = 0.0025# same scale as above |
198 | | -#effective_cache_size =1000# typically 8kB each |
| 198 | +#effective_cache_size =8000kB |
199 | 199 |
|
200 | 200 | # - Genetic Query Optimizer - |
201 | 201 |
|
|
243 | 243 | # or size-driven rotation. Default is |
244 | 244 | # off, meaning append to existing files |
245 | 245 | # in all cases. |
246 | | -#log_rotation_age =1440# Automatic rotation of logfiles will |
247 | | -# happen afterso many minutes. 0 to |
| 246 | +#log_rotation_age =1d# Automatic rotation of logfiles will |
| 247 | +# happen afterthat time. 0 to |
248 | 248 | # disable. |
249 | | -#log_rotation_size =10240# Automatic rotation of logfiles will |
250 | | -# happen afterso many kilobytes of log |
| 249 | +#log_rotation_size =10MB# Automatic rotation of logfiles will |
| 250 | +# happen afterthat much log |
251 | 251 | # output. 0 to disable. |
252 | 252 |
|
253 | 253 | # These are relevant when logging to syslog: |
|
297 | 297 | # panic(off) |
298 | 298 |
|
299 | 299 | #log_min_duration_statement = -1# -1 is disabled, 0 logs all statements |
300 | | -# and their durations, in milliseconds. |
| 300 | +# and their durations. |
301 | 301 |
|
302 | 302 | #silent_mode = off# DO NOT USE without syslog or |
303 | 303 | # redirect_stderr |
|
362 | 362 | #--------------------------------------------------------------------------- |
363 | 363 |
|
364 | 364 | #autovacuum = off# enable autovacuum subprocess? |
365 | | -#autovacuum_naptime =60# time between autovacuum runs, in secs |
| 365 | +#autovacuum_naptime =1min# time between autovacuum runs |
366 | 366 | #autovacuum_vacuum_threshold = 500# min # of tuple updates before |
367 | 367 | # vacuum |
368 | 368 | #autovacuum_analyze_threshold = 250# min # of tuple updates before |
|
372 | 372 | #autovacuum_analyze_scale_factor = 0.1# fraction of rel size before |
373 | 373 | # analyze |
374 | 374 | #autovacuum_vacuum_cost_delay = -1# default vacuum cost delay for |
375 | | -#autovac, -1 means use |
| 375 | +#autovacuum, -1 means use |
376 | 376 | # vacuum_cost_delay |
377 | 377 | #autovacuum_vacuum_cost_limit = -1# default vacuum cost limit for |
378 | | -#autovac, -1 means use |
| 378 | +#autovacuum, -1 means use |
379 | 379 | # vacuum_cost_limit |
380 | 380 |
|
381 | 381 |
|
|
391 | 391 | #check_function_bodies = on |
392 | 392 | #default_transaction_isolation = 'read committed' |
393 | 393 | #default_transaction_read_only = off |
394 | | -#statement_timeout = 0# 0 is disabled, in milliseconds |
| 394 | +#statement_timeout = 0# 0 is disabled |
395 | 395 |
|
396 | 396 | # - Locale and Formatting - |
397 | 397 |
|
|
427 | 427 | # LOCK MANAGEMENT |
428 | 428 | #--------------------------------------------------------------------------- |
429 | 429 |
|
430 | | -#deadlock_timeout =1000# in milliseconds |
| 430 | +#deadlock_timeout =1s |
431 | 431 | #max_locks_per_transaction = 64# min 10 |
432 | 432 | # (change requires restart) |
433 | 433 | # Note: each lock table slot uses ~270 bytes of shared memory, and there are |
|