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...")
 
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
Last update: 2019/06/24
+
Last update: 2019/11/01
  
 
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
 
Each bug items assigned "SL (Severity level)" from 1-3 (1 is the most severe, 3 is the least severe) in "Status" column.
Line 13: Line 13:
 
! Overview
 
! Overview
 
! Status
 
! Status
−
|-style="background:silver"
+
|-style="background:beige;text-align:center;"
−
| <s>001</s>
+
| colspan="10" | Feature
−
| <s>[FEATURE] Cert authentication between Pgpool-II and PostgreSQL</s>
+
|-style="background:white"
 +
| 001
 +
| [FEATURE] Cert authentication between Pgpool-II and PostgreSQL
 
|  
 
|  
 
|  
 
|  
Line 22: Line 24:
 
|
 
|
 
|
 
|
−
| 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 35:
 
| 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 44:
 
|
 
|
 
|
 
|
−
| 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 53:
 
|  
 
|  
 
|
 
|
−
| <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 61: Line 63:
 
| Small
 
| Small
 
|
 
|
−
| [http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
+
| [https://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 73:
 
|  
 
|  
 
|
 
|
−
| <s>[http://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]</s>
+
| [https://www.sraoss.jp/pipermail/pgpool-hackers/2018-February/002721.html [pgpool-hackers: 2721]]
−
| Removed from 4.1. 2018/11/29
+
|  
−
|-style="background:silver"
+
|-style="background:white"
 
| 007
 
| 007
−
| [FEATURE] shared relation cache
+
| [FEATURE] Support for LDAP authentication
−
| 2018/11/20
+
| 2018/11/29
−
| 2019/02/29
+
|  
 
| High
 
| High
−
| Large
+
| Medium
 
| Hoshiai
 
| 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:white"
 +
| 008
 +
| [FEATURE] Add IPv6 sppport for Pgpool-II
 +
| 2019/01/17
 
|  
 
|  
−
|-style="background:beige"
+
| Low
−
| [FEATURE] Enhance performance: performance for simple query
 
−
| 2018/11/20
 
−
|
 
−
|
 
−
| XLarge
 
−
| Usama
 
−
|
 
 
|  
 
|  
−
|-style="background:silver"
+
| Ishii
−
| [FEATURE] Enhance performance: performance for extended query
 
−
| 2019/01/17
 
 
|
 
|
 
|
 
|
 +
|-style="background:white"
 +
| 009
 +
| [FEATURE] Fault injection for watchdog
 +
| 2019/09/18
 
|  
 
|  
 +
| High
 +
| Medium
 
| Ishii
 
| Ishii
 +
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-September/003434.html [pgpool-hackers: 3434]]
 +
|
 +
|-style="background:white"
 +
| 010
 +
| [FEATURE] using volatility categories to determine whether a function is read only or not
 +
| 2019/09/19
 
|  
 
|  
−
| (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
+
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-September/003438.html [pgpool-hackers: 3438]]
 +
|
 +
|-style="background:white"
 +
| 011
 +
| [FEATURE] add the process status of pgpool for extended query
 +
| 2019/10/17
 
|  
 
|  
−
| 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
+
| Hoshiai
 +
|[https://www.pgpool.net/pipermail/pgpool-hackers/2019-October/003460.html [pgpool-hackers: 3460]]
 +
|
 +
|-style="background:white"
 +
| 012
 +
| [FEATURE] Implement log process
 +
| 2019/11/01
 
|  
 
|  
−
| Usama
 
 
|  
 
|  
 
|  
 
|  
−
|-style="background:beige"
 
−
| 010
 
−
| [FEATURE] Master watchdog sets quarantine state to primary node
 
−
| 2018/11/26
 
 
|  
 
|  
−
| Normal
+
|
−
| Small
+
|
−
| Usama
+
|-style="background:white"
−
| [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]]
+
| 013
 +
| [FEATURE] Check if the PID or socket file exists at startup.
 +
| 2019/11/01
 
|  
 
|  
−
|-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
 
| 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
 
−
| [FEATURE] Support for LDAP authentication
 
−
| 2018/11/29
 
−
|
 
−
| High
 
−
| Medium
 
−
| Usama
 
 
|
 
|
 
|
 
|
−
|-style="background:silver"
+
|-style="background:white"
 
| 014
 
| 014
−
| [FEATURE] Support for PostgreSQL 12.
+
| [FEATURE] Simplify WATCHDOG host configurations.
−
| 2018/11/29
+
| 2019/11/01
 +
|
 +
|
 
|  
 
|  
−
| High
 
−
| Small
 
−
| Ishii
 
−
| 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]
 
−
|-style="background:beige"
 
−
| 015
 
−
| [FEATURE] Import PostgreSQL 12 parser.
 
−
| 2018/11/29
 
−
| 2019/07/31
 
−
| High
 
−
| Medium
 
 
| Peng
 
| Peng
 +
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-December/003480.html [pgpool-hackers: 3480]]
 
|  
 
|  
−
| Start after PostgreSQL beta release.
+
|-style="background:white"
−
|-style="background:silver"
+
| 015
−
| 016
+
| [FEATURE] Add internal process application name
−
| [FEATURE] Statement level load balancing
+
| 2019/11/01
−
| 2018/12/06
 
−
| 2019/03/31
 
−
| High
 
−
| Large
 
−
| Peng
 
−
|
 
−
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb commit]
 
−
|-style="background:beige"
 
−
| 017
 
−
| [FEATURE] Add IPv6 sppport for Pgpool-II
 
−
| 2019/01/17
 
 
|  
 
|  
−
| Low
 
 
|  
 
|  
−
| Ishii
 
−
|
 
−
|
 
−
|-style="background:silver"
 
−
| 018
 
−
| [FEATURE] Add new columns to "show pool_nodes" command
 
−
| 2019/04/22
 
−
| 2019/04/24
 
−
| High
 
−
| Medium
 
−
| Ishii
 
−
| Discussion: [https://www.pgpool.net/pipermail/pgpool-hackers/2019-April/003315.html [pgpool-hackers: 3315]]
 
−
| Done. [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35cb1dc2d9d9f4887bd0407f150558660b7826e1 Commit]
 
−
|-style="background:silver"
 
−
| 019
 
−
| [FEATURE][Document] Add new performance section
 
 
|  
 
|  
−
|
 
−
| High
 
−
| Medium
 
−
| Ishii
 
 
|  
 
|  
 
|
 
|
−
|-style="background:beige"
 
−
| 020
 
−
| [FEATURE] auto failback
 
−
| 2019/5/23
 
−
| 2019/7/5
 
−
|
 
−
| Medium
 
−
| Hoshiai
 
−
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003328.html [pgpool-hackers: 3328]]
 
 
|
 
|
−
|-style="background:beige"
+
|-style="background:beige;text-align:center;"
−
| 021
+
| colspan="10" | Bug Fix
−
| [FEATURE] allow to use md5 password in health_check_password and sr_check_password
+
|-style="background:white"
−
| 2019/5/30
+
| 101
−
| 2019/6/10
+
| [https://www.sraoss.jp/pipermail/pgpool-general/2019-December/006849.html [pgpool-general: 6791] Re: VIP and quorum ]
 
|  
 
|  
−
| Medium
 
−
| Ishii
 
−
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003334.html [pgpool-hackers: 3334]]
 
−
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=dc9742678dd04719a08a747d40cd4c0781fce49a commit]
 
−
|-style="background:beige"
 
−
| 022
 
−
| [FEATURE] Routing relcache queries to load balance node
 
 
|  
 
|  
 
|  
 
|  
 
|  
 
|  
−
| Medium
+
| Usama
−
| Ishii
 
−
| [https://www.pgpool.net/pipermail/pgpool-hackers/2019-June/003342.html [pgpool-hackers: 3342]]
 
 
|
 
|
−
|-style="background:beige"
 
−
| 023
 
−
| [FEATURE] Support ECDH key exchange with SSL
 
−
|
 
−
|
 
−
|
 
−
| Medium
 
−
| Hoshiai
 
 
|  
 
|  
−
| [https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=51bc494aaa7fd191e14038204d18effe2efb0ec8 commit]
+
|-style="background:beige;text-align:center;"
 +
| colspan="10" | Roadmap
 
|-style="background:white"
 
|-style="background:white"
 
| 201
 
| 201

Latest revision as of 00:19, 1 December 2020

Last update: 2019/11/01

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
Feature
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]
007 [FEATURE] Support for LDAP authentication 2018/11/29 High Medium Hoshiai
008 [FEATURE] Add IPv6 sppport for Pgpool-II 2019/01/17 Low Ishii
009 [FEATURE] Fault injection for watchdog 2019/09/18 High Medium Ishii [pgpool-hackers: 3434]
010 [FEATURE] using volatility categories to determine whether a function is read only or not 2019/09/19 [pgpool-hackers: 3438]
011 [FEATURE] add the process status of pgpool for extended query 2019/10/17 Hoshiai [pgpool-hackers: 3460]
012 [FEATURE] Implement log process 2019/11/01
013 [FEATURE] Check if the PID or socket file exists at startup. 2019/11/01 Peng
014 [FEATURE] Simplify WATCHDOG host configurations. 2019/11/01 Peng [pgpool-hackers: 3480]
015 [FEATURE] Add internal process application name 2019/11/01
Bug Fix
101 [pgpool-general: 6791 Re: VIP and quorum ] Usama
Roadmap
201 Feature Agreement
202 Feature Freeze
202 Code Freeze
Retrieved from "https://pgpool.net/mediawiki/index.php?title=Pgpool-II_4.2_development&oldid=3387"