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

From Tom Lane
Subject Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Date
Msg-id 22219.1443154651@sss.pgh.pa.us
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
aaron@heyaaron.com writes:
> I tried importing again with the swap file in-place, and it consumed all the
> memory and crashed.  I tried disabling swap, starting psql, then enabling
> swap and I was able to restore the same majority of tables.

That's odd.  Was it psql itself that was exhausting memory, or the
connected backend?

> I do have the ~2.3 GB backup of the DB which bzip's down to ~550 MB if any
> developers are interested in playing/testing.

That sounds too big for email, but if you have another way to get it
to me, I'd take a look.

            regards, tom lane

pgsql-bugs by date:

Previous
From: aaron@heyaaron.com
Date:
Subject: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Next
From: "Aaron C. de Bruyn"
Date:
Subject: Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM