[pgpool-general: 4928] Re: Transaction Mode and Statement Mode

[Steven Livingstone]

Definitely. Let me do some testing today Tatsuo to make sure it is working
as expected and I'll forward details here.

Thanks,
Steven

On 18 Aug 2016 1:33 a.m., "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:

> > Thanks Tatsuo.
> >
> > I believe you were part of a discussion on it so hope this clarifies your
> > understanding:
> >
> > http://www.sraoss.jp/pipermail/pgpool-hackers/2013-May/000255.html
>
> Thanks for providing the link. It was me who were using the term
> "transaction mode" and "statement mode". Sorry for confusion.
>
> > Appreciate you confirming the current situation. I put pgbouncer in front
> > of pgpool and it seems to be OK ( at first sight).
>
> Great. I am interested in the configuration. I would appreciate if you
> follow up this when you find something with this configuration in the
> field later on.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > Regards
> > Steven
> >
> > On 18 Aug 2016 1:07 a.m., "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:
> >
> >> > Hi all.
> >> >
> >> > I am configuring an application to use PGPool with Postgres and one of
> >> > the libraries I am using requires me to configure PG Pool in
> >> > transaction mode rather than statement mode.
> >> >
> >> > I can find some stuff on PG Bouncer and an old discussion on here on
> >> > adding support for it ....
> >> >
> >> > Is there any support for it in PG Pool II ?
> >>
> >> Not sure what you mean by "transaction mode" nor "statement mode", but
> >> if I look into into this:
> >>
> >> https://wiki.postgresql.org/wiki/PgBouncer
> >>
> >> I would say Pgpool-II supports only "session pooling". Pgpool-II does
> >> not support "transaction pooling" nor "statement pooling".
> >>
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS, Inc. Japan
> >> English: http://www.sraoss.co.jp/index_en.php
> >> Japanese:http://www.sraoss.co.jp
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160818/afcac5fa/attachment.html>