Re: Out of memory error on pg_restore

Поиск
Список
Период
Сортировка
От Nik
Тема Re: Out of memory error on pg_restore
Дата
Msg-id 1141854715.290662.96550@i40g2000cwc.googlegroups.com
обсуждение исходный текст
Ответ на Re: Out of memory error on pg_restore  ("Moises Alberto Lindo Gutarra" <mlindo@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Nik"
Дата:
Сообщение: Re: Out of memory error on pg_restore
Следующее
От: "Nik"
Дата:
Сообщение: Storage Estimates