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

[Ari Kahn <akahn1@xxxxxxx>]

> "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