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

From Ari Kahn
Subject Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
Date
Msg-id 4D4003BB-27AA-4890-BA6C-0A30D48149EC@gmu.edu
Whole thread Raw
In response to psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)  (Ari Kahn <akahn1@gmu.edu>)
Responses Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error
List 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,
> Qingqin

I have LOTS of memory (5GB).
What is the appropriate way to add more memory slots?
Or increase my VM file size?

Something in the postgresql.conf?

Thanks,
Ari


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Different exponent in error messages
Next
From: Qingqing Zhou
Date:
Subject: Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error