View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000165 | Pgpool-II | Bug | public | 2016-01-26 02:04 | 2016-01-29 14:09 |
| Reporter | alexign | Assigned To | Muhammad Usama | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Linux | OS | Centos | OS Version | 7.1.1503 |
| Summary | 0000165: Performance degradation(x250) while using ipv6 | ||||
| Description | Performance 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) | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
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 |
| 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 |
