Re: Out of memory error on pg_restore - Mailing list pgsql-general

From Nik
Subject Re: Out of memory error on pg_restore
Date
Msg-id 1141854715.290662.96550@i40g2000cwc.googlegroups.com
Whole thread Raw
In response to Re: Out of memory error on pg_restore  ("Moises Alberto Lindo Gutarra" <mlindo@gmail.com>)
List pgsql-general
Tom was exactly right.

I was trying to restore the dump file into an already created table
structure that did have three foreign key constraints. I removed the
primary key constraint to speed up the load, but was not aware of the
memory usage of the foreign keys.

I dropped the table and ran the pg_restore again, and it is running
currently and behaving nicely at constant 13Mb of memory. It will
probably take some time, but I think it is working fine.

Thanks for the help.


pgsql-general by date:

Previous
From: "Nik"
Date:
Subject: Re: Out of memory error on pg_restore
Next
From: "Nik"
Date:
Subject: Storage Estimates