[Pgpool-general] slow pgpool-II-3.1

[Armin Nesiren]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111006/37391d06/attachment.html>