Any idea how to successfully run a query that large? What’s the size limit of a query?
Without seeing your actual query (or a syntactically similar one, if there are private details you can't disclose), it's difficult to say. In general, though, a couple of thoughts come to mind:
Can you run it as a single COPY statement, instead of however many individual INSERTS? Failing that, can you use the multi-row VALUES syntax for your INSERT?
As an aside, this type of question is probably more suited for the pgsql-sql list, rather than -admin.