Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM

Поиск
Список
Период
Сортировка
От Aaron C. de Bruyn
Тема Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Дата
Msg-id CAEE+rGqX8Gk6CASjLriQDCLXV7XRhRC8_DY+6_gijHbVHdJtkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM  (Greg Stark <stark@mit.edu>)
Список pgsql-bugs
That's the only error I got.  It spit out a few rows showing SQL
commands being processed, then it would die with "out of memory" or
just return to the command prompt.

I ended up destroying the DB and re-creating it since it didn't have
any critical data in it.

-A

On Wed, Oct 14, 2015 at 12:31 AM, Greg Stark <stark@mit.edu> wrote:
> On Fri, Sep 25, 2015 at 3:06 AM,  <aaron@heyaaron.com> wrote:
>> It runs for a few minutes, and then I either get an out of memory error, or
>> it appears to exit normally without importing the data.
>>
>> Thinking it was because my 'dev' server is only 512 MB, I temporarily scaled
>> it up to 8 GB.  Same error.
>
> I would suggest posting the actual error. There are various errors
> that can be read as "out of memory" but they're not really the same
> thing. If you had free memory on the machine then which error it was
> specifically might be important. Also Postgres prints more information
> than just "out of memory" and that additional context could be
> helpful.
>
> --
> greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13679: Planer chooses not optimal plan
Следующее
От: b.yordanov2@gmail.com
Дата:
Сообщение: BUG #13680: PostgreSQL backend process crashes on jsonb_object_agg() in plpgsql recursive function