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

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
Date: 2006-01-11 21:25:01
Message-ID: dq3t11$o97$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Ari Kahn" <akahn1(at)gmu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Assad Jarrahian 2006-01-11 21:40:04 getting access to geodistance (what do I need to install/enable) in an existing db install
Previous Message Tom Lane 2006-01-11 21:09:23 Re: Different exponent in error messages