Richard Huxton wrote:
Kirk Wythers wrote:
I am trying to do fairly simple joins on climate databases that should
return ~ 7 million rows of data. However, I'm getting an error message
on a OS X (10.4 tiger server) machine that seems to imply that I am
running out of memory. The errors are:
psql(15811) malloc: *** vm_allocate(size=8421376) failed (error code=3)
Is this actually in psql - the client code rather than the backend?
Could it be that its allocating memory for its 7million result rows and
running out of space for your user account?
Hi,
If you look at the message carefully, it looks like (for me) that the
client is running out of memory. Can't allocate that 8,4MB :)
Regards,
Akos
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
