Amr-Shams commented on issue #989:
URL: https://github.com/apache/age/issues/989#issuecomment-1591108810

   I have asked a similar question [Stack 
Overflow](https://stackoverflow.com/questions/76340552/cannot-change-max-function-args-parameter-in-postgresql)
 
   In brief, the options to workaround the Postgres 100 argument limit in this 
case are:
   
   1- Use an array as a single argument instead of individual arguments
   2- Split the large array into multiple smaller arrays and pass each as a 
separate argument
   3- Increase the max_function_args config parameter and recompile Postgres 
(not recommended)
   4- Handle large arrays in the application layer instead of in the database
   The preferred options are #1 and #2 - use array types and split into 
multiple arrays. Option #3, recompiling Postgres, is not recommended and should 
only be used as a last resort.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to