"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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
