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

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