|
122 | 122 |
|
123 | 123 | # - Cost-Based Vacuum Delay -
|
124 | 124 |
|
125 |
| -#vacuum_cost_delay =0# 0-100 milliseconds |
| 125 | +#vacuum_cost_delay =0ms# 0-100 milliseconds |
126 | 126 | #vacuum_cost_page_hit = 1# 0-10000 credits
|
127 | 127 | #vacuum_cost_page_miss = 10# 0-10000 credits
|
128 | 128 | #vacuum_cost_page_dirty = 20# 0-10000 credits
|
|
175 | 175 | # (change requires restart)
|
176 | 176 | #archive_command = ''# command to use to archive a logfile segment
|
177 | 177 | #archive_timeout = 0# force a logfile segment switch after this
|
178 |
| -#time; 0 is off |
| 178 | +#number of seconds; 0 is off |
179 | 179 |
|
180 | 180 |
|
181 | 181 | #------------------------------------------------------------------------------
|
|
306 | 306 | # fatal
|
307 | 307 | # panic (effectively off)
|
308 | 308 |
|
309 |
| -#log_min_duration_statement = -1ms# -1 is disabled, 0 logs all statements |
| 309 | +#log_min_duration_statement = -1# -1 is disabled, 0 logs all statements |
310 | 310 | # and their durations, > 0 logs only
|
311 |
| -# statements running at least this time. |
| 311 | +# statements running at least this number |
| 312 | +# of milliseconds |
312 | 313 |
|
313 | 314 | #silent_mode = off# DO NOT USE without syslog or
|
314 | 315 | # logging_collector
|
|
346 | 347 | #log_lock_waits = off# log lock waits >= deadlock_timeout
|
347 | 348 | #log_statement = 'none'# none, ddl, mod, all
|
348 | 349 | #log_temp_files = -1# log temporary files equal or larger
|
349 |
| -# than specified size; |
| 350 | +# thanthespecified size in kilobytes; |
350 | 351 | # -1 disables, 0 logs all temp files
|
351 | 352 | #log_timezone = unknown# actually, defaults to TZ environment
|
352 | 353 | # setting
|
|
382 | 383 | # requires track_counts to also be on.
|
383 | 384 | #log_autovacuum_min_duration = -1# -1 disables, 0 logs all actions and
|
384 | 385 | # their durations, > 0 logs only
|
385 |
| -# actions running at least that time. |
| 386 | +# actions running at least this number |
| 387 | +# of milliseconds. |
386 | 388 | #autovacuum_max_workers = 3# max number of autovacuum subprocesses
|
387 | 389 | #autovacuum_naptime = 1min# time between autovacuum runs
|
388 | 390 | #autovacuum_vacuum_threshold = 50# min number of row updates before
|
|
393 | 395 | #autovacuum_analyze_scale_factor = 0.1# fraction of table size before analyze
|
394 | 396 | #autovacuum_freeze_max_age = 200000000# maximum XID age before forced vacuum
|
395 | 397 | # (change requires restart)
|
396 |
| -#autovacuum_vacuum_cost_delay =20# default vacuum cost delay for |
397 |
| -# autovacuum,-1 means use |
398 |
| -# vacuum_cost_delay |
| 398 | +#autovacuum_vacuum_cost_delay =20ms# default vacuum cost delay for |
| 399 | +# autovacuum,in milliseconds; |
| 400 | +#-1 means usevacuum_cost_delay |
399 | 401 | #autovacuum_vacuum_cost_limit = -1# default vacuum cost limit for
|
400 | 402 | # autovacuum, -1 means use
|
401 | 403 | # vacuum_cost_limit
|
|
415 | 417 | #default_transaction_isolation = 'read committed'
|
416 | 418 | #default_transaction_read_only = off
|
417 | 419 | #session_replication_role = 'origin'
|
418 |
| -#statement_timeout = 0# 0 is disabled |
| 420 | +#statement_timeout = 0#in milliseconds,0 is disabled |
419 | 421 | #vacuum_freeze_min_age = 50000000
|
420 | 422 | #vacuum_freeze_table_age = 150000000
|
421 | 423 | #xmlbinary = 'base64'
|
|