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

From Aaron C. de Bruyn
Subject Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Date
Msg-id CAEE+rGqX8Gk6CASjLriQDCLXV7XRhRC8_DY+6_gijHbVHdJtkg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM  (Greg Stark <stark@mit.edu>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13679: Planer chooses not optimal plan
Next
From: b.yordanov2@gmail.com
Date:
Subject: BUG #13680: PostgreSQL backend process crashes on jsonb_object_agg() in plpgsql recursive function