Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8CF1C9FB2BB for ; Fri, 2 Feb 2007 13:59:57 -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 71387-09 for ; Fri, 2 Feb 2007 13:59:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B908A9FA339 for ; Fri, 2 Feb 2007 13:59:45 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l12HxdMu022068; Fri, 2 Feb 2007 12:59:40 -0500 (EST) To: Kirk Wythers cc: "Steinar H. Gunderson" , =?ISO-8859-1?Q?G=E1briel_=C1kos?= , pgsql-performance@postgresql.org Subject: Re: trouble with a join on OS X In-reply-to: <1189F1A6-7CB8-40C3-9CE0-24AE95EFB5F9@umn.edu> 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> Comments: In-reply-to Kirk Wythers message dated "Fri, 02 Feb 2007 11:54:20 -0600" Date: Fri, 02 Feb 2007 12:59:39 -0500 Message-ID: <22067.1170439179@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/24 X-Sequence-Number: 23078 Kirk Wythers writes: > However, setting ulimit to unlimited does not seem to solve the > issue. Output from ulimit -a is: Possibly a silly question, but you are running the client code under the shell session that you adjusted ulimit for, yes? regards, tom lane