Postgres Pro
Downloads
Home   >   mailing lists

Re: out of memory error with large insert - Mailing list pgsql-admin

From Tom Lane
Subject Re: out of memory error with large insert
Date
Msg-id 3869.1142980707@sss.pgh.pa.us
Whole thread Raw
In response to out of memory error with large insert  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List pgsql-admin
Tree view 
"Sriram Dandapani" <sdandapani@counterpane.com> writes:
> On a large transaction involving an insert of 8 million rows, after a
> while Postgres complains of an out of memory error.

If there are foreign-key checks involved, try dropping those constraints
and re-creating them afterwards.  Probably faster than retail checks
anyway ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: out of memory error with large insert
Next
From: "Sriram Dandapani"
Date:
Subject: Re out of memory error with large insert