Public feed #380489

Stuff

public text v1 · immutable
Raw Edit
·published 2007-03-04 03:08 UTC
rendered paste body

listen_addresses = '*'		# what IP address(es) to listen on; 

max_connections = 60			# (change requires restart)

shared_buffers = 128MB


max_fsm_pages = 20000		# min max_fsm_relations*16, 6 bytes each
					# (change requires restart)
effective_cache_size = 128MB

stats_command_string = on
#update_process_title = on

stats_start_collector = on		# needed for block or row stats
					# (change requires restart)
#stats_block_level = off
stats_row_level = on 

autovacuum = on			# enable autovacuum subprocess?

autovacuum_naptime = 1min		# time between autovacuum runs
autovacuum_vacuum_threshold = 500	# min # of tuple updates before
					# vacuum
autovacuum_analyze_threshold = 250	# min # of tuple updates before 
					# analyze
autovacuum_vacuum_scale_factor = 0.2	# fraction of rel size before 
					# vacuum
autovacuum_analyze_scale_factor = 0.1	# fraction of rel size before 
					# analyze
autovacuum_freeze_max_age = 200000000	# maximum XID age before forced vacuum
					# (change requires restart)
autovacuum_vacuum_cost_delay = -1	# default vacuum cost delay for 
					# autovacuum, -1 means use 
					# vacuum_cost_delay
autovacuum_vacuum_cost_limit = -1	# default vacuum cost limit for 

datestyle = 'iso, mdy'
lc_messages = 'C'			# locale for system error message 
					# strings
lc_monetary = 'C'			# locale for monetary formatting
lc_numeric = 'C'			# locale for number formatting
lc_time = 'C'				# locale for time formatting
dynamic_library_path = '$libdir'