Out of memory running 560 MB query

From: "Morgan Ramsay" <morgan(dot)ramsay(at)gmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Out of memory running 560 MB query
Date: 2014-09-15 00:18:51
Message-ID: 1a9b601cfd07a$a16c71a0$e44554e0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have 560 MB worth of INSERT statements in a .sql file. I'm trying to run
that query but I'm getting an out of memory error.

Any idea how to successfully run a query that large? What's the size limit
of a query?

-Morgan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rosser Schwarz 2014-09-15 00:28:09 Re: Out of memory running 560 MB query
Previous Message Axel Rau 2014-09-13 17:55:12 New certs give "could not accept SSL connection: sslv3 alert certificate unknow"