Hi everyone, I'm experiencing performance issues with pgpool-3.1 Problem is that when I connect through pgpool to database, database works slower than when I connect directly to master. In this test case, I have disabled node2, just to check performance directly and through pgpool.
What can be a problem? As you can see in my pgpool.conf I have set num_init_children to 32, and I have max_pool to 3. max_connections in postgresql.conf is set to 100. Also, should I set num_init_children and max_pool comparing to one node, or should I multiply value by number of nodes? Here is my pgpool.conf: listen_addresses = '*' port = 9999 socket_dir = '/tmp' pcp_port = 9898 pcp_socket_dir = '/tmp' backend_hostname0 = 'node1.hostname' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/pgdata/data901.C' backend_flag0 = 'ALLOW_TO_FAILOVER' #backend_hostname1 = 'node2.hostname' #backend_port1 = 5432 #backend_weight1 = 1 #backend_data_directory1 = '/pgdata/data90.C' #backend_flag1 = 'ALLOW_TO_FAILOVER' enable_pool_hba = on authentication_timeout = 60 # - SSL Connections - ssl = on ssl_key = '/usr/local/etc/server.key' ssl_cert = '/usr/local/etc/server.crt' num_init_children = 32 max_pool = 3 child_life_time = 300 child_max_connections = 0 connection_life_time = 0 client_idle_limit = 0 log_destination = 'syslog' print_timestamp = on log_connections = on log_hostname = off log_statement = off log_per_node_statement = off log_standby_delay = 'if_over_threshold' syslog_facility = 'LOCAL0' syslog_ident = 'pgpool' replication_stop_on_mismatch = off debug_level = 1 pid_file_name = '/var/run/pgpool/pgpool.pid' logdir = '/tmp' connection_cache = on reset_query_list = 'ABORT; DISCARD ALL' replication_mode = off replicate_select = off insert_lock = on lobj_lock_table = '' load_balance_mode = on ignore_leading_white_space = on white_function_list = '' black_function_list = 'currval,lastval,nextval,find_record_position,setval,foo,array2_order_and_flatten,distinct_array_append' master_slave_mode = on master_slave_sub_mode = 'stream' sr_check_period = 0 sr_check_user = 'postgres' sr_check_password = '' delay_threshold = 0 follow_master_command = '' parallel_mode = off enable_query_cache = off pgpool2_hostname = '' system_db_hostname = 'node1.hostname' system_db_port = 54322 system_db_dbname = 'pgpool' system_db_schema = 'pgpool_catalog' system_db_user = 'pgpool' system_db_password = 'password' health_check_period = 10 health_check_timeout = 20 health_check_user = 'postgres' health_check_password = 'password' failover_command = '/usr/local/pgpool-II/etc/failover.sh %d "%h" %p %D %m %M "%H" %P' failback_command = '/usr/local/pgpool-II/etc/failback.sh %d "%h" %p %D %m %M "%H" %P' fail_over_on_backend_error = on recovery_user = 'postgres' recovery_password = 'password' recovery_1st_stage_command = 'basebackup.sh' recovery_2nd_stage_command = '' recovery_timeout = 30 client_idle_limit_in_recovery = 0 relcache_expire = 0 -- Armin
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general