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

From Greg Stark
Subject Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Date
Msg-id CAM-w4HPsW=eqisUfioOEmv8Wg1G71HxcsBhT4e2UNPivTRtn3w@mail.gmail.com
Whole thread Raw
In response to BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM  (aaron@heyaaron.com)
Responses Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM  ("Aaron C. de Bruyn" <aaron@heyaaron.com>)
List pgsql-bugs
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: Pavel Stehule
Date:
Subject: Re: BUG #13677: CPU 100% for WITH RECURSIVE CTE Queries
Next
From: i.frolkov@postgrespro.ru
Date:
Subject: BUG #13679: Planer chooses not optimal plan