Message-ID: <45C4B175.1090707@007Marketing.com>
Date: Sun, 04 Feb 2007 02:29:49 +1030
From: Shane Ambler <pgsql@007Marketing.com>
User-Agent: Thunderbird 1.5.0.8 (Macintosh/20061025)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Kirk Wythers <kwythers@umn.edu>,
	"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>
In-Reply-To: <24768.1170454736@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:

> Since this is just a bog-standard Mini with 512M memory, it was pretty
> thoroughly on its knees by this point :-(.  I'm not sure how to find out
> about allocated swap space in OS X, but my bet is that the above message
> should be understood as "totally out of virtual memory".

just so you can look into it for your own curiosity ;-) - Mac OS X uses 
the startup disk for VM storage. You can find the files in - /var/vm

You will find the swapfiles there, the size of the swapfiles 
progressively get larger - swapfile0 and 1 are 64M then 2 is 128M, 3 is 
256M, 4 is 512M, 5 is 1G.... each is preallocated so it only gives you a 
rough idea of how much vm is being used. You would run out when your 
startup disk is full, though most apps probably hit the wall at 4G of vm 
unless you have built a 64bit version.

The 4G (32bit) limit may be where you hit the out of memory errors (or 
is postgres get around that with it's caching?).


-- 

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz