Re: postgres_fdw: Emit message when batch_size is reduced

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres_fdw: Emit message when batch_size is reduced
Date: 2026-06-05 17:52:01
Message-ID: CADkLM=fDPqgPQOBBBb-rhND-hCXSuujnvOvCRUaNjY=S4XvvkA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
>
>>> - In the test case, choosing a batch_size > PQ_QUERY_PARAM_MAX_LIMIT
>>> seems a bit artificial, in that it's a value that can't work for any query
>>> with parameters, and someone might add sanity checks to batch_size in
>>> option.c, which would in turn invalidate the test case. A test case with a
>>> 2-column table should be able to get the same effect any batch_size greater
>>> than half of 65535, yes?
>>>
>>
>>
>>
>
Thinking some more on this part, I think it would be worthwhile to check on
assignments to batch_size, and issue a NOTICE or WARNING that the set value
exceeds PQ_QUERY_PARAM_MAX_LIMIT, but does not reject the change because
this value could theoretically (but very unlikely) get smaller in the
future and we don't want to mess up any pg_restores or pg_upgrades.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2026-06-05 18:05:08 [PATCH] CI: Add a CPAN cache on Windows
Previous Message Baji Shaik 2026-06-05 17:44:24 [PATCH] Fix memory leak in pgstat_progress_parallel_incr_param()