From: Shane Ambler <pgsql@007Marketing.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kirk Wythers <kwythers@umn.edu>
Cc: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: Gábriel Ákos <akos.gabriel@i-logic.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: trouble with a join on OS X
Date: Sun, 04 Feb 2007 02:29:49 +1030
Message-ID: <45C4B175.1090707@007Marketing.com> (raw)
In-Reply-To: <24768.1170454736@sss.pgh.pa.us>
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>
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
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: pgsql@007Marketing.com, tgl@sss.pgh.pa.us, kwythers@umn.edu, sgunderson@bigfoot.com, akos.gabriel@i-logic.hu
Subject: Re: trouble with a join on OS X
In-Reply-To: <45C4B175.1090707@007Marketing.com>
* 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