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

Tatsuo Ishii ishii at sraoss.co.jp
Mon Mar 27 09:23:54 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".

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v2-0001-Judge-multi-statement-query-using-psqlscan.patch
Type: text/x-patch
Size: 83650 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20230327/cbc2c458/attachment-0001.bin>


More information about the pgpool-hackers mailing list