View Issue Details

IDProjectCategoryView StatusLast Update
0000165Pgpool-IIBugpublic2016-01-29 14:09
ReporteralexignAssigned ToMuhammad Usama 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformLinuxOSCentosOS Version7.1.1503
Product Version 
Target VersionFixed in Version 
Summary0000165: Performance degradation(x250) while using ipv6
DescriptionPerformance degradation(x250) while using ipv6 (config attached).
[root@thunder2 ~]# /usr/bin/pgpool -v
pgpool-II version 3.4.3 (tataraboshi)
[postgres@thunder2 postgresql]$ ~/usr/local/pgsql95/bin/pgbench --version
pgbench (PostgreSQL) 9.5rc1
Steps To Reproduce[postgres@thunder2 postgresql]$ ~/usr/local/pgsql95/bin/pgbench -h ::1 -p 9999 -s 10 -j 10 -c 30 -S -M prepared -T 10 scale option ignored, using count from pgbench_branches table (10)
starting vacuum...end.
transaction type: SELECT only
scaling factor: 10
query mode: prepared
number of clients: 30
number of threads: 10
duration: 10 s
number of transactions actually processed: 7043
latency average: 42.595 ms
tps = 702.196150 (including connections establishing)
tps = 716.529380 (excluding connections establishing)
[postgres@thunder2 postgresql]$ ~/usr/local/pgsql95/bin/pgbench -h 127.0.0.1 -p 9999 -s 10 -j 10 -c 30 -S -M prepared -T 10
scale option ignored, using count from pgbench_branches table (10)
starting vacuum...end.
transaction type: SELECT only
scaling factor: 10
query mode: prepared
number of clients: 30
number of threads: 10
duration: 10 s
number of transactions actually processed: 254267
latency average: 1.180 ms
tps = 25409.332721 (including connections establishing)
tps = 25845.114747 (excluding connections establishing)

TagsNo tags attached.

Activities

alexign

2016-01-26 02:04

reporter  

pgpool.conf (33,092 bytes)

Muhammad Usama

2016-01-29 14:09

developer   ~0000642

Thank you for reporting the issue.
I have found the problem and pushed the fix in master and 3_4 stable branches.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=bd8d78be7d3ea600804b6541e95d7c45ee8f3361

Issue History

Date Modified Username Field Change
2016-01-26 02:04 alexign New Issue
2016-01-26 02:04 alexign File Added: pgpool.conf
2016-01-27 15:53 t-ishii Assigned To => Muhammad Usama
2016-01-27 15:53 t-ishii Status new => assigned
2016-01-29 14:09 Muhammad Usama Note Added: 0000642
2016-01-29 14:09 Muhammad Usama Status assigned => resolved
2016-01-29 14:09 Muhammad Usama Resolution open => fixed