[pgpool-hackers: 4297] Re: minimal parser and multi-statement query

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 28 19:18:51 JST 2023


>>>> I temporarily turns off the optimization and adds regression test for
>>>> that in master branch.
>>>>     
>>>> Hopefully before releasing 4.5 we find a way to determine whether the
>>>> query is a multi-statement query or not in less expensive way. And if
>>>> it is not a multi-statement query, we can turn on the optimization.
>>> 
>>> Maybe we use this in the PostgreSQL source code:
>>> 
>>> src/fe_utils/psqlscan.c
>> 
>> Attached is the patch to import psqlscan.c (and other necessary
>> files).
> 
> Attached is the v2 patch.
> 
> - Never use minimal parser if pgpool is in replication or snapshot
>   isolation mode. Before introducing psqlscan, we did that way. I just
>   forgot it.
> 
> - unbreak "make dist".

I have pushed the v2 patch to master branch.
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=48da8715bf403965507eef0321c0ab10054ac71c

Although this could be regarded as a bug fix, I hesitate to back patch
to stable branches because the patch size is relatively
large. Comments/suggestions?

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list