Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3) - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
Date
Msg-id dq3t11$o97$1@news.hub.org
Whole thread Raw
In response to psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)  (Ari Kahn <akahn1@gmu.edu>)
List pgsql-general
"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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Different exponent in error messages
Next
From: Assad Jarrahian
Date:
Subject: getting access to geodistance (what do I need to install/enable) in an existing db install