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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aaron(at)heyaaron(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Date: 2015-09-25 04:17:31
Message-ID: 22219.1443154651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

aaron(at)heyaaron(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Aaron C. de Bruyn 2015-09-25 04:22:47 Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM
Previous Message Tom Lane 2015-09-25 04:06:31 Re: BUG #13636: psql numericlocale adds comma where it ought not