Difference between revisions of "Pgpool-II 4.2 development"

From pgpool Wiki
Jump to: navigation, search
(Created page with "Last update: 2019/06/24 Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column. {| class="wikitable" ! ! ID...")
 
Line 13: Line 13:
 
! Overview
 
! Overview
 
! Status
 
! Status
|-style="background:silver"
+
|-style="background:white"
| <s>001</s>
+
| 001
| <s>[FEATURE] Cert authentication between Pgpool-II and PostgreSQL</s>
+
| [FEATURE] Cert authentication between Pgpool-II and PostgreSQL
 
|  
 
|  
 
|  
 
|  
Line 22: Line 22:
 
|
 
|
 
|
 
|
| Removed from 4.1. 2018/11/29
+
|  
|-style="background:beige"
+
|-style="background:white"
 
| 002
 
| 002
 
| [FEATURE] Add new child if it goes down
 
| [FEATURE] Add new child if it goes down
Line 33: Line 33:
 
| pgpool-hackers:1034
 
| pgpool-hackers:1034
 
|
 
|
|- style="background:silver"
+
|- style="background:white"
| <s>003</s>
+
| 003
| <s>[FEATURE] Make PCP set configuration command public </s>
+
| [FEATURE] Make PCP set configuration command public
 
|  
 
|  
 
|  
 
|  
Line 42: Line 42:
 
|
 
|
 
|
 
|
| Removed from 4.1. 2018/11/29
+
|  
|- style="background:silver"
+
|- style="background:white"
| <s>004</s>
+
| 004
| <s>[FEATURE] Seamless Application Failover</s>
+
| [FEATURE] Seamless Application Failover
 
|  
 
|  
 
|  
 
|  
Line 51: Line 51:
 
|  
 
|  
 
|
 
|
| <s>Similar to Oracle's "Transparent Application Failover".</s>
+
| Similar to Oracle's "Transparent Application Failover".
| Removed from 4.1. 2018/11/29
+
|  
|-style="background:beige"
+
|-style="background:white"
 
| 005
 
| 005
 
| [FEATURE] Enhancing pool_process and pool_pools
 
| [FEATURE] Enhancing pool_process and pool_pools
Line 63: Line 63:
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
 
|  
 
|  
|-style="background:silver"
+
|-style="background:white"
| <s>006</s>
+
| 006
| <s>[FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE)</s>
+
| [FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE)
 
|  
 
|  
 
|
 
|
Line 71: Line 71:
 
|  
 
|  
 
|
 
|
| <s>[http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]</s>
+
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
| Removed from 4.1. 2018/11/29
 
|-style="background:silver"
 
| 007
 
| [FEATURE] shared relation cache
 
| 2018/11/20
 
| 2019/02/29
 
| High
 
| Large
 
| Hoshiai
 
| [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]
 
|-style="background:beige"
 
| rowspan="3" | 008
 
| [FEATURE] Enhance performance: performance regression test
 
| 2018/11/20
 
|
 
| High
 
| Small
 
| Usama
 
|
 
|
 
|-style="background:beige"
 
| [FEATURE] Enhance performance: performance for simple query
 
| 2018/11/20
 
|
 
|
 
| XLarge
 
| Usama
 
|
 
|
 
|-style="background:silver"
 
| [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): [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]
 
|-style="background:beige"
 
| rowspan="3" | 009
 
| [Documentation] Review and improve the current document
 
| 2018/11/20
 
|
 
| High
 
| Extra Large
 
| Hoshiai
 
|
 
|
 
|-style="background:silver"
 
| [Documentation] Update the examples to latest version.
 
| 2018/11/20
 
|
 
| High
 
|
 
| Peng
 
|
 
| 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:beige"
 
| [Documentation] Add a "Quik start" guid.
 
| 2018/11/20
 
 
|  
 
|  
| High
+
|-style="background:white"
|
 
| Usama
 
|
 
|
 
|-style="background:beige"
 
| 010
 
| [FEATURE] Master watchdog sets quarantine state to primary node
 
| 2018/11/26
 
|
 
| Normal
 
| Small
 
| Usama
 
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-March/002756.html [pgpool-hackers: 2756]] <br>[https://www.pgpool.net/pipermail/pgpool-general-jp/2018-March/001503.html [pgpool-general-jp: 1504]]
 
|
 
|-style="background:silver"
 
| 011
 
| [FEATURE] limiting number of frontends differently
 
| 2018/11/26
 
| 2018/12/04
 
|
 
|
 
| Ishii
 
| [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]
 
|-style="background:beige"
 
| 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
 
| [https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003157.html [pgpool-hackers: 3157]]
 
| Implementation is done. TODO: Test & Doc.
 
|-style="background:beige"
 
 
| 013  
 
| 013  
 
| [FEATURE] Support for LDAP authentication  
 
| [FEATURE] Support for LDAP authentication  

Revision as of 04:03, 25 June 2019

Last update: 2019/06/24

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
001 [FEATURE] Cert authentication between Pgpool-II and PostgreSQL
002 [FEATURE] Add new child if it goes down 2015/09/03 - Low Small pgpool-hackers:1034
003 [FEATURE] Make PCP set configuration command public
004 [FEATURE] Seamless Application Failover Similar to Oracle's "Transparent Application Failover".
005 [FEATURE] Enhancing pool_process and pool_pools 2018/02/13 Low Small [pgpool-hackers: 2721]
006 [FEATURE] Support more prefix for query routing (similar to NO LOAD BALANCE) [pgpool-hackers: 2721]
013 [FEATURE] Support for LDAP authentication 2018/11/29 High Medium Usama
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
017 [FEATURE] Add IPv6 sppport for Pgpool-II 2019/01/17 Low Ishii
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
020 [FEATURE] auto failback 2019/5/23 2019/7/5 Medium Hoshiai [pgpool-hackers: 3328]
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] commit
022 [FEATURE] Routing relcache queries to load balance node Medium Ishii [pgpool-hackers: 3342]
023 [FEATURE] Support ECDH key exchange with SSL Medium Hoshiai commit
201 Feature Agreement
202 Feature Freeze
202 Code Freeze