Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 278B19FB200 for ; Fri, 2 Feb 2007 10:50:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 31088-06 for ; Fri, 2 Feb 2007 10:50:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smarty.gabriel.co.hu (smarty.gabriel.co.hu [195.70.37.16]) by postgresql.org (Postfix) with ESMTP id 38C039FB1DC for ; Fri, 2 Feb 2007 10:50:28 -0400 (AST) Received: from localhost (smarty [127.0.0.1]) by smarty.gabriel.co.hu (Postfix) with ESMTP id D6FCE5814B for ; Fri, 2 Feb 2007 15:50:24 +0100 (CET) Received: from smarty.gabriel.co.hu ([127.0.0.1]) by localhost (smarty [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 14018-01-5 for ; Fri, 2 Feb 2007 15:50:24 +0100 (CET) Received: from [192.168.111.135] (customer-174.radio-net.hu [217.113.54.174]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smarty.gabriel.co.hu (Postfix) with ESMTP id A90D757E64 for ; Fri, 2 Feb 2007 15:50:24 +0100 (CET) Message-ID: <45C34FC6.2020704@i-logic.hu> Date: Fri, 02 Feb 2007 15:50:46 +0100 From: =?ISO-8859-1?Q?G=E1briel_=C1kos?= Organization: I-Logic Kft User-Agent: Thunderbird 2.0b2 (Windows/20070116) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: trouble with a join on OS X References: <8FD54F8B-792B-4333-8C73-AAFD2992C17F@umn.edu> <45C34E80.7010805@archonet.com> In-Reply-To: <45C34E80.7010805@archonet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at gabriel.co.hu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/17 X-Sequence-Number: 23071 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