Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)

"Ari Kahn" <akahn1@gmu.edu> wrote
> I'm doing a query that really should be too taxing. But when I  execute it
> I get the following error(s):
>
> psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
>
> Nested Loop  (cost=89.36..6086.42 rows=273312 width=88) (actual
> time=0.113..24456.508 rows=54952794 loops=1)

Maybe 54952794 rows is too much for your client machine? Try add more memory
slots or increase your vm file size.

Regards,
Qingqing