From: Gábriel Ákos <akos.gabriel@i-logic.hu>
To: pgsql-performance@postgresql.org
Subject: Re: trouble with a join on OS X
Date: Fri, 02 Feb 2007 15:50:46 +0100
Message-ID: <45C34FC6.2020704@i-logic.hu> (raw)
In-Reply-To: <45C34E80.7010805@archonet.com>
References: <8FD54F8B-792B-4333-8C73-AAFD2992C17F@umn.edu>
<45C34E80.7010805@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: akos.gabriel@i-logic.hu
Subject: Re: trouble with a join on OS X
In-Reply-To: <45C34FC6.2020704@i-logic.hu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox