You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "Amr-Shams (via GitHub)" <gi...@apache.org> on 2023/06/14 12:35:19 UTC

[GitHub] [age] Amr-Shams commented on issue #989: Impossible to create an object with an array field of more than 100 elements

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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org