Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id B2DCF9FB1DF
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  5 Feb 2007 13:50:22 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 29186-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  5 Feb 2007 13:50:14 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net
	[203.16.214.141])
	by postgresql.org (Postfix) with ESMTP id 5A7EA9FB1BE
	for <pgsql-performance@postgresql.org>;
	Mon,  5 Feb 2007 13:50:14 -0400 (AST)
Received: from ppp247-71.static.internode.on.net (HELO [192.168.8.200])
	([203.122.247.71])
	by ipmail02.adl2.internode.on.net with ESMTP; 06 Feb 2007 04:20:13 +1030
X-IronPort-AV: i="4.13,284,1167571800";
	d="scan'208"; a="80695385:sNHT21475720"
Message-ID: <45C76E53.60104@007Marketing.com>
Date: Tue, 06 Feb 2007 04:20:11 +1030
From: Shane Ambler <pgsql@007Marketing.com>
User-Agent: Thunderbird 1.5.0.8 (Macintosh/20061025)
MIME-Version: 1.0
To: Kirk Wythers <kwythers@umn.edu>
CC: Tom Lane <tgl@sss.pgh.pa.us>,
	"Steinar H. Gunderson" <sgunderson@bigfoot.com>,
	=?ISO-8859-1?Q?G=E1briel_=C1kos?= <akos.gabriel@i-logic.hu>,
	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> <45C34FC6.2020704@i-logic.hu>
	<21989.1170431213@sss.pgh.pa.us>
	<079F46AF-287E-4FC5-818E-B593C8C73D06@umn.edu>
	<20070202160903.GA21442@uio.no> <25286.1170432709@sss.pgh.pa.us>
	<1189F1A6-7CB8-40C3-9CE0-24AE95EFB5F9@umn.edu>
	<24768.1170454736@sss.pgh.pa.us>
	<45C4B175.1090707@007Marketing.com>
	<6378BE0C-8803-4A1F-A977-F3AA53E91F20@umn.edu>
In-Reply-To: <6378BE0C-8803-4A1F-A977-F3AA53E91F20@umn.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.273 tagged_above=0 required=5 tests=AWL, BAYES_40,
	BIZ_TLD, SPF_HELO_PASS
X-Spam-Level: *
X-Archive-Number: 200702/48
X-Sequence-Number: 23102

Kirk Wythers wrote:

>> The 4G (32bit) limit may be where you hit the out of memory errors (or 
>> is postgres get around that with it's caching?).
> 
> Any idea if postgres on OS X can truely access more that 4 gigs if the 
> 64 bit version is built? I have tried building the 64 bit version of 
> some other apps on OS X, and I have never been convinced that they 
> behaved as true 64 bit.
> 

I haven't tried myself



-- 

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz