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

[Tatsuo Ishii]

> 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
>>