Postgres Pro
Downloads
Home   >   mailing lists

Out of memory running 560 MB query - Mailing list pgsql-admin

From Morgan Ramsay
Subject Out of memory running 560 MB query
Date
Msg-id 1a9b601cfd07a$a16c71a0$e44554e0$@gmail.com
Whole thread Raw
Responses Re: Out of memory running 560 MB query  (Rosser Schwarz <rosser.schwarz@gmail.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Axel Rau
Date:
Subject: New certs give "could not accept SSL connection: sslv3 alert certificate unknow"
Next
From: Rosser Schwarz
Date:
Subject: Re: Out of memory running 560 MB query