Re: pg_restore out of memory

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: pg_restore out of memory
Дата
Msg-id cone.1182189157.392756.81364.5001@35st.simplicato.com
обсуждение исходный текст
Ответ на pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-general
Tom Lane writes:

> If that actually is the length of the line, the only answer is to raise
> the memory ulimit setting the postmaster runs under.

Did another test to try to see if the problem is that row or the size of the
row.

Another record of greater size also failed.

Any ideas what this 84MB limit could be from?
I have shared_buffers at 450MB
maintenance_work_mem = 64MB (which I increased to 100MB with the same
result)

OS limit for applications at 1.6GB.
Also when I start postgresql I see several postgresql processes using 400M+
so I don't see how it could be the Os limit.


В списке pgsql-general по дате отправления:

Предыдущее
От: Guy Rouillier
Дата:
Сообщение: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle