Re: pg_restore out of memory

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

> But that is a false assertion that the limit is 512Mb.  On a random
> system of mine running FreeBSD/i386 it shows the default data limit
> as 1Gb, and on a random FreeBSD/amd64 box I see it at about 32Gb.  I
> do no global tweaking of the size limits.

Understood.
I only showed "limit" because it was asked.
I already set /boot/loader.conf to 1600MB.
Also the error is about running out of memory when trying to allocate 84MB.
The default FreeBSD limit is 512MB so 84MB is well below that.

At this point this is basically stopping me from loading a table and so
far I have not been able to get any insight into how this could be fixed.

I wonder if there is any additional debuging I can turn on to help better
troubleshoot this.

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
Следующее
От: "Matt Bartolome"
Дата:
Сообщение: Re: pg_resetxlog command not found