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

[Muhammad Usama]

> On 14-Apr-2023, at 5:37 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> Hi Usama,
> 
>> Thanks for conducting the tests.
> 
> No prolem.
> 
>> 3-4 % seems quite a significant degradation. So one possible way would bet
>> retire the
>> minimal parser and always use the standard parser so that we can save the
>> extra scanning
>> needed for the detection of multi-statement queries.
>> 
>> It (removing minimal parser altogether) may be less of a performance
>> overhead than this. What is your opinion?
> 
> Is it possible to run the extra scanning only for lengthy queries(say,
> longer than 10k)? i.e.
> 
> If (lengthy query)
>  extra scanning;
>  if (single-statement)
>    minimal_parser = true;
>  else
>    minimal_parser = false;
> else
>  minimal_parser = false;
> fi
> raw_parser (minimal_parser);
> 
> With this, we can avoid the extra scanning for most queries. I think
> the minimal parser is best for lengthy queries.
> 

Agreed, I guess that makes total sense

Best regards
Muhammad Usama

> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: https://url.avanan.click/v2/___http://www.sraoss.co.jp/index_en/___.YXAzOnBlcmNvbmE6YTpnOjcwNGY2Y2U0OTFiYTNiYmUyMTY3MDdhYzQ5ZWYyODU0OjY6YmU5NzozYjhhOTZjN2Y5MWZhOWMyMTQ4M2EwZDBlZjFiZmU4ZGFlNDNjYzI2N2NlODRmNjljOTFlMzYxMDg4M2JjMWVjOnA6VA
> Japanese:https://url.avanan.click/v2/___http://www.sraoss.co.jp___.YXAzOnBlcmNvbmE6YTpnOjcwNGY2Y2U0OTFiYTNiYmUyMTY3MDdhYzQ5ZWYyODU0OjY6MzJjMjplMWRmZWNkNTI4MDhlMjI4MzUzNzg5OTljN2NiN2UwMWQ0YTYwYTRmY2VlMWRiMzRmNmZkOGVjYTAxYTVlZWFiOnA6VA