Re: trouble with a join on OS X - Mailing list pgsql-performance

From Gábriel Ákos
Subject Re: trouble with a join on OS X
Date
Msg-id 45C34FC6.2020704@i-logic.hu
Whole thread Raw
In response to Re: trouble with a join on OS X  (Richard Huxton <dev@archonet.com>)
Responses Re: trouble with a join on OS X  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: trouble with a join on OS X
Next
From: Tom Lane
Date:
Subject: Re: trouble with a join on OS X