[pgpool-hackers: 3860] Inappropriate compiled defaults for config variables

Tatsuo Ishii ishii at sraoss.co.jp
Mon Dec 14 09:43:22 JST 2020


I noticed some of compiled defaults for config variables are not
appropreate or we can make it better.

app_name_redirect_preference_list	# default is NULL. probably empty string is better.

authentication_timeout	# compiled default is 0. 60 is better, and it's the one in pgpool.conf.sample and PostgreSQL's default.

database_redirect_preference_list	# default is NULL. probably empty string is better.

dml_adaptive_object_relationship_list	# default is NULL. probably empty string is better.

health_check_period			# default is 0. should be 10 or so.

health_check_database			# default is empty string. probably "postgres" etc. is better.

listen_backlog_multiplier		# default is 32. Probably too high. 2 is better.

load_balance_mode 			# default is off. I think true is better.

log_standby_delay			# default is none. if_over_threshold is better.

write_function_list			# default is 'nextval,setval'. should be empty string.

sr_check_period				# default is 0. should be 10 or so.


Comments and suggestions are welcome.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list