How many rows I can insert in single time with execute_values command in Postgres database? I am using latest PostgreSQL (version 12) and executing this command in python.
It probably is limited by the amount of RAM. But rather than creating huge statements, use COPY and stream the data to the server.
Maximum row insert limit | execute_values Command | Postgres