[pgpool-hackers: 578] Re: WIP patch for PG94 parser import

Tatsuo Ishii ishii at postgresql.org
Wed Jul 9 21:09:44 JST 2014


> On Mon, Jul 7, 2014 at 4:54 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> > Tatsuo,
>> > What is the remaining todo list for 3.4? Do you have a beta date in mind?
>>
>> Out of our TODOs: (http://pgpool.net/mediawiki/index.php/TODO)
>>     1.1 Enhance performance of extended protocol case
>>     1.2 Ability to load balance based on Client IP, database, table etc.
>>     1.3 Automatically reattach a node in streaming master/slave
>> configuration
>>     1.4 Allow to use client encoding
>>     1.5 Send read query only to standbys even after fail over
>>     1.6 Recognize multi statemnet queries
>>     1.7 Cursor statements are not load balanced, sent to all DB nodes in
>> replication mode
>>     1.8 Support IPV6 network
>>     1.9 Handle abnormal down of virtual IP interface when watchdog enabled
>>     1.10 Do not invalidate query cache created in a transaction in some
>> cases
>>     1.11 Fix memory leak in pool_config.c
>>     1.12 Add SET commnad
>>     1.13 Put together a definition of error codes into a single header file
>>     1.14 Create separate process for health checking
>>     1.15 Import PostgreSQL's latch module
>>     1.16 Remove parallel query
>>     1.17 Add switch to control select(2) time out in connecting to
>> PostgreSQL
>>
>> I think followings are important and could be doable for 3.4:
>>
>>     1.2 Ability to load balance based on Client IP, database, table etc.
>>     1.11 Fix memory leak in pool_config.c
>>     1.17 Add switch to control select(2) time out in connecting to
>> PostgreSQL
>>
>> Also remember that we should fix all issues reported by Coverity.
>>
>> Probably this is also very important:
>>     1.1 Enhance performance of extended protocol case
>>
> 
> Some of the above items like fixing all coverity issues and 1.1 might be
> very time consuming. This could impact the release date for 3.4.

I agree that coverity issues is time consuming. However I think this
is a must item for 3.4. We are developing a database clustering
tool. IMO #1 priority for that kind of tool is quality and stability.

As for 1.1 I'm not so sure we should include in 3.4 because it seems
no one has concrete idea how to implement it.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

>> but I don't know how to implement at this moment.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> >> > Hi
>> >> >
>> >> > Please find the attached mega patch for importing the PG94 parser.
>> >> >
>> >> > --Usama
>> >> >
>> >> >
>> >> > On Fri, Jun 27, 2014 at 6:26 AM, Tatsuo Ishii <ishii at postgresql.org>
>> > wrote:
>> >> >
>> >> >> Usama,
>> >> >>
>> >> >> I have briefly looked into your patches and it seems they are good.
>> >> >> Also I have tested a few 9.4's new syntax and pgpool-II successfully
>> >> >> handles it.  Good work! Please go head.
>> >> >>
>> >> >> Best regards,
>> >> >> --
>> >> >> Tatsuo Ishii
>> >> >> SRA OSS, Inc. Japan
>> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >> >> Japanese:http://www.sraoss.co.jp
>> >> >>
>> >> >> > Usama,
>> >> >> >
>> >> >> > Thank you very much for the work.
>> >> >> > I will look into this.
>> >> >> >
>> >> >> > Best regards,
>> >> >> > --
>> >> >> > Tatsuo Ishii
>> >> >> > SRA OSS, Inc. Japan
>> >> >> > English: http://www.sraoss.co.jp/index_en.php
>> >> >> > Japanese:http://www.sraoss.co.jp
>> >> >> >
>> >> >> >> Hi
>> >> >> >>
>> >> >> >> I am working on updating pgpool-II parser to PG94's parser, and
>> till
>> >> >> time I
>> >> >> >> have imported the changes from PostgreSQL source to pgpool-II,
>> > There are
>> >> >> >> still some TODOs and compiler warnings needed to be fixed, which I
>> > am
>> >> >> >> currently working on and hopefully be finished soon. Meanwhile can
>> > you
>> >> >> >> please review the attached WIP patch if I have missed or overdone
>> >> >> something.
>> >> >> >>
>> >> >> >> Thanks
>> >> >> >> Usama
>> >> >> > _______________________________________________
>> >> >> > pgpool-hackers mailing list
>> >> >> > pgpool-hackers at pgpool.net
>> >> >> > http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>> >> >>
>> >> _______________________________________________
>> >> pgpool-hackers mailing list
>> >> pgpool-hackers at pgpool.net
>> >> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>>
> 
> 
> 
> -- 
> Ahsan Hadi
> Snr Director Product Development
> EnterpriseDB Corporation
> The Enterprise Postgres Company
> 
> Phone: +92-51-8358874
> Mobile: +92-333-5162114
> 
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com/
> Follow us on Twitter: http://www.twitter.com/enterprisedb
> 
> This e-mail message (and any attachment) is intended for the use of the
> individual or entity to whom it is addressed. This message contains
> information from EnterpriseDB Corporation that may be privileged,
> confidential, or exempt from disclosure under applicable law. If you are
> not the intended recipient or authorized to receive this for the intended
> recipient, any use, dissemination, distribution, retention, archiving, or
> copying of this communication is strictly prohibited. If you have received
> this e-mail in error, please notify the sender immediately by reply e-mail
> and delete this message.


More information about the pgpool-hackers mailing list