Re: Out of memory running 560 MB query

On Sun, Sep 14, 2014 at 5:18 PM, Morgan Ramsay <morgan(dot)ramsay(at)gmail(dot)com>
wrote:

> 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.

rls

--
:wq