[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