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

[Ahsan Hadi]

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.


>
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20140709/d693f016/attachment.html>