Difference between revisions of "Pgpool-II 4.1 development"
Line 23: | Line 23: | ||
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]] | | [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003124.html [pgpool-hackers: 3124]] | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46917d5458a82c75e98b247a74b7ee1827666159 commit] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46917d5458a82c75e98b247a74b7ee1827666159 commit] | ||
− | |-style="background: | + | |-style="background:beige" |
| rowspan="3" | 008 | | rowspan="3" | 008 | ||
| [FEATURE] Enhance performance: performance regression test | | [FEATURE] Enhance performance: performance regression test | ||
Line 33: | Line 33: | ||
| | | | ||
| | | | ||
− | |-style="background: | + | |-style="background:beige" |
| [FEATURE] Enhance performance: performance for simple query | | [FEATURE] Enhance performance: performance for simple query | ||
| 2018/11/20 | | 2018/11/20 | ||
Line 52: | Line 52: | ||
| (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=702f7c86f9b8f82f61e47235505715891ffe1b23 commit] <br> | | (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=702f7c86f9b8f82f61e47235505715891ffe1b23 commit] <br> | ||
(2) Enhance performance for extended query message: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003230.html [pgpool-hackers: 3230]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=778f611e201d6df88ed90d01e49af77daf9f2926 commit] <br> (3) Eliminate select(2) calls in certain cases to enhance performance in simple and extended query: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003247.html [pgpool-hackers: 3247]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=cf5fe7eb89a11e3ada3833343c7ed6551ce7c662 commit] | (2) Enhance performance for extended query message: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003230.html [pgpool-hackers: 3230]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=778f611e201d6df88ed90d01e49af77daf9f2926 commit] <br> (3) Eliminate select(2) calls in certain cases to enhance performance in simple and extended query: <br> [https://www.pgpool.net/pipermail/pgpool-hackers/2019-February/003247.html [pgpool-hackers: 3247]] [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=cf5fe7eb89a11e3ada3833343c7ed6551ce7c662 commit] | ||
− | |-style="background: | + | |-style="background:beige" |
| rowspan="2" | 009 | | rowspan="2" | 009 | ||
| [Documentation] Review and improve the current document | | [Documentation] Review and improve the current document | ||
Line 62: | Line 62: | ||
| | | | ||
| | | | ||
− | |-style="background: | + | |-style="background:beige" |
| [Documentation] Update the examples to latest version. | | [Documentation] Update the examples to latest version. | ||
| 2018/11/20 | | 2018/11/20 | ||
Line 71: | Line 71: | ||
| | | | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0c9f716714dce156fe74469a933046b39896a072 commit] [http://www.pgpool.net/docs/latest/en/html/example-cluster.html doc] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0c9f716714dce156fe74469a933046b39896a072 commit] [http://www.pgpool.net/docs/latest/en/html/example-cluster.html doc] | ||
− | |-style="background: | + | |-style="background:beige" |
| 010 | | 010 | ||
| [FEATURE] Master watchdog sets quarantine state to primary node | | [FEATURE] Master watchdog sets quarantine state to primary node | ||
Line 91: | Line 91: | ||
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-November/003153.html [pgpool-hackers: 3153]] | | [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-November/003153.html [pgpool-hackers: 3153]] | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc commit] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc commit] | ||
− | |-style="background: | + | |-style="background:beige" |
| 012 | | 012 | ||
| [FEATURE] Don't load balance after a SELECT having functions specified in black function list | | [FEATURE] Don't load balance after a SELECT having functions specified in black function list | ||
Line 111: | Line 111: | ||
| recovery.conf <br> pgpool_setup <br> pgppol-recovery extension | | recovery.conf <br> pgpool_setup <br> pgppol-recovery extension | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=fda13a93a1025b498bb2a674fb49406d9e3e509c pgpool-recovery extension] <br> [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=23fb4c1250f0464a867f2ac69006d74f134213e3 pgpool_setup] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=fda13a93a1025b498bb2a674fb49406d9e3e509c pgpool-recovery extension] <br> [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=23fb4c1250f0464a867f2ac69006d74f134213e3 pgpool_setup] | ||
− | |-style="background: | + | |-style="background:beige" |
| 015 | | 015 | ||
| [FEATURE] Import PostgreSQL 12 parser. | | [FEATURE] Import PostgreSQL 12 parser. | ||
Line 151: | Line 151: | ||
| | | | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=854659a17b958536e80c461d55c9ba0f1032a128 commit] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=854659a17b958536e80c461d55c9ba0f1032a128 commit] | ||
− | |-style="background: | + | |-style="background:beige" |
| 020 | | 020 | ||
| [FEATURE] auto failback | | [FEATURE] auto failback | ||
Line 181: | Line 181: | ||
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]] | | [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]] | ||
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46986ebc0be77e4b011b94b097789fec9e3f5b0f commit] | | Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=46986ebc0be77e4b011b94b097789fec9e3f5b0f commit] | ||
− | |-style="background: | + | |-style="background:beige" |
| 023 | | 023 | ||
| [FEATURE] Support ECDH key exchange with SSL | | [FEATURE] Support ECDH key exchange with SSL |
Revision as of 00:35, 26 June 2019
Last update: 2019/06/25
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
ID | Registered/start Date | Target Date | Priority | Implementation | Person in charge | Overview | Status | |
---|---|---|---|---|---|---|---|---|
007 | [FEATURE] shared relation cache | 2018/11/20 | 2019/02/29 | High | Large | Hoshiai | [pgpool-hackers: 3124] | Done. commit |
008 | [FEATURE] Enhance performance: performance regression test | 2018/11/20 | High | Small | Usama | |||
[FEATURE] Enhance performance: performance for simple query | 2018/11/20 | XLarge | Usama | |||||
[FEATURE] Enhance performance: performance for extended query | 2019/01/17 | Ishii | (1) Enhance performance for COPY XXX TO STDOUT (both for simple and extended query): commit (2) Enhance performance for extended query message: | |||||
009 | [Documentation] Review and improve the current document | 2018/11/20 | High | Extra Large | Hoshiai | |||
[Documentation] Update the examples to latest version. | 2018/11/20 | High | Peng | Done. commit doc | ||||
010 | [FEATURE] Master watchdog sets quarantine state to primary node | 2018/11/26 | Normal | Small | Usama | [pgpool-hackers: 2756] [pgpool-general-jp: 1504] |
||
011 | [FEATURE] limiting number of frontends differently | 2018/11/26 | 2018/12/04 | Ishii | [pgpool-hackers: 3153] | Done. commit | ||
012 | [FEATURE] Don't load balance after a SELECT having functions specified in black function list | 2018/11/29 | 2019/06/30 | Normal | Small | Peng | [pgpool-hackers: 3157] | Implementation is done. TODO: Test & Doc. |
014 | [FEATURE] Support for PostgreSQL 12. | 2018/11/29 | High | Small | Ishii | recovery.conf pgpool_setup pgppol-recovery extension |
Done. pgpool-recovery extension pgpool_setup | |
015 | [FEATURE] Import PostgreSQL 12 parser. | 2018/11/29 | 2019/07/31 | High | Medium | Peng | Start after PostgreSQL beta release. | |
016 | [FEATURE] Statement level load balancing | 2018/12/06 | 2019/03/31 | High | Large | Peng | Done. commit | |
018 | [FEATURE] Add new columns to "show pool_nodes" command | 2019/04/22 | 2019/04/24 | High | Medium | Ishii | Discussion: [pgpool-hackers: 3315] | Done. Commit |
019 | [FEATURE][Document] Add new performance section | High | Medium | Ishii | Done. commit | |||
020 | [FEATURE] auto failback | 2019/5/23 | 2019/7/5 | Medium | Hoshiai | [pgpool-hackers: 3328] | In progress. | |
021 | [FEATURE] allow to use md5 password in health_check_password and sr_check_password | 2019/5/30 | 2019/6/10 | Medium | Ishii | [pgpool-hackers: 3334] | Done. commit | |
022 | [FEATURE] Routing relcache queries to load balance node | Medium | Ishii | [pgpool-hackers: 3342] | Done. commit | |||
023 | [FEATURE] Support ECDH key exchange with SSL | Medium | Hoshiai | In progress. commit1 | ||||
101 | 0000433: IN (SELECT ...) can not be rewritten in native replication mode | 2018/10/19 | Peng | bug433 | Done. commit Regression test should be added. | |||
102 | 0000434: Segmentation fault due to a query error and Sync messages in native replication mode | 2018/10/19 | Hoshiai | bug434 | Done. commit | |||
103 | pool_passwd is corrupted. | 2018/10/22 | Hoshiai, Usama | [pgpool-hackers: 3081] | Done. commit | |||
104 | [pgpool-hackers: 3025] Compile warns | 2018/10/22 | Hoshiai | [pgpool-hackers: 3025] | Done. commit | |||
105 | 0000443: Segmentation fault occurs when a certain Bind message is sent in native replication mode. | 2018/11/08 | Peng | bug443 | Done. commit | |||
106 | 0000444: pgpool does not take into account parameters order in startup packet | 2018/11/13 | Hoshiai | bug444 | Done. commit | |||
107 | 0000448: pgpool holds the connections as idle_in_transaction which are timed out due to idle_in_transaction setting on backend nodes | 2018/11/29 | Ishii | bug448 | Done. cimmit | |||
108 | [pgpool-general: 6351] kind mismatch among backends, savepoint with psqlodbc | 2018/12/26 | Peng | [pgpool-general: 6351] | ||||
109 | 0000455: watchdog lifecheck process has segfalut in query mode | 2019/01/21 | Usama | https://www.pgpool.net/mantisbt/view.php?id=455 | Done. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=4cde5da1b416d909d102cfe6878c0cd5189caf86 | |||
110 | Add regression test for query mode | 2019/01/21 | Peng | |||||
111 | 0000483: online-recovery is blocked after a child process exits abnormally with replication mode and watchdog | 2019/04/04 | Usama | bug483 | Waiting for review->the patch did not work. | |||
112 | Fix memory leak related to watchdog and auth pointed out by coverity | 2019/05/22 | Usama | src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c | ||||
113 | Fix memory leak related to watchdog and auth pointed out by coverity | 2019/05/22 | ishii | other than :src/auth/pool_hba.c src/auth/pool_auth.c src/auth/auth-scram.c src/watchdog/watchdog.c src/watchdog/wd_lifecheck.c src/config/pool_config_variable.c | ||||
201 | Feature Agreement | |||||||
202 | Feature Freeze | 2019/07/31 | ||||||
202 | Code Freeze | 2019/08/31 |