|
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' |
|