Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XTK0j-0006dZ-T2 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Sep 2014 00:19:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XTK0i-0002Xb-VV for pgsql-admin@arkaria.postgresql.org; Mon, 15 Sep 2014 00:19:17 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XTK0h-0002XS-Im for pgsql-admin@postgresql.org; Mon, 15 Sep 2014 00:19:15 +0000 Received: from mail-pa0-x22e.google.com ([2607:f8b0:400e:c03::22e]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XTK0Y-0000WA-C9 for pgsql-admin@postgresql.org; Mon, 15 Sep 2014 00:19:13 +0000 Received: by mail-pa0-f46.google.com with SMTP id kq14so5192960pab.5 for ; Sun, 14 Sep 2014 17:19:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:subject:date:message-id:mime-version:content-type :thread-index:content-language; bh=Yenj6BbX4ftXvwHKjEps9Kdzp6JJU3EUc89rXCK6VEE=; b=uYc+1CxZAZb0hAEkr/AMM0C2WydDgR5hy0cmWE/a20PUznh+0v4GfBkEB4c0XaV+PH Y2aIP7qLOXKxuQ+aCkTt/q2AA6ghV//UzP5wCEklggw7m4GTJ1B0M3tn7rPZhd/D1hx2 zaVHYW2tm6o3DMJ3WpiMU/6G0BlHllYI9ageBqvYuZRLuSxoTdP2Ixl9NYsMS9Y3HXTs OYN3QnLV6vl9I5ynlziO9uFgYlZS3zjOZ0Is9I+gGU5Ph8aoXONWPNJboI7b5yfCW7uG iWbxrnIKvnYx6aQqqMlG29kzsELhvP3SOS0S3EfSgbLk6CBJBcarvab8nqsDhR2EtOMs QpEA== X-Received: by 10.69.19.202 with SMTP id gw10mr33939538pbd.106.1410740344671; Sun, 14 Sep 2014 17:19:04 -0700 (PDT) Received: from Heretic (ip72-197-173-101.sd.sd.cox.net. [72.197.173.101]) by mx.google.com with ESMTPSA id yp10sm10091317pac.18.2014.09.14.17.19.02 for (version=TLSv1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Sun, 14 Sep 2014 17:19:03 -0700 (PDT) From: "Morgan Ramsay" To: Subject: Out of memory running 560 MB query Date: Sun, 14 Sep 2014 17:18:51 -0700 Message-ID: <1a9b601cfd07a$a16c71a0$e44554e0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_1A9B7_01CFD03F.F50DE7C0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac/Qegahm+uaZuuXT+aGNj4UZs7pZw== Content-Language: en-us X-Antivirus: avast! (VPS 140914-1, 09/14/2014), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_1A9B7_01CFD03F.F50DE7C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_1A9B7_01CFD03F.F50DE7C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_1A9B7_01CFD03F.F50DE7C0--