Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A931F2E011A for ; Sat, 31 May 2008 15:53:32 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65028-07-4 for ; Sat, 31 May 2008 15:53:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from davinci.ethosmedia.com (unknown [209.128.84.227]) by developer.postgresql.org (Postfix) with ESMTP id 9DD6F2E0101 for ; Sat, 31 May 2008 15:52:58 -0300 (ADT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO [192.168.2.3]) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 16835067; Sat, 31 May 2008 11:52:56 -0700 From: Josh Berkus Organization: PostgreSQL @ Sun To: Simon Riggs Subject: Re: 2GB or not 2GB Date: Sat, 31 May 2008 11:53:13 -0700 User-Agent: KMail/1.8.2 Cc: pgsql-performance@postgresql.org References: <200805281659.26945.josh@agliodbs.com> <1212219897.4120.195.camel@ebony.site> In-Reply-To: <1212219897.4120.195.camel@ebony.site> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200805311153.13186.josh@agliodbs.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/381 X-Sequence-Number: 30349 Simon, > There is an optimum for each specific sort. Well, if the optimum is something other than "as much as we can get", then we still have a pretty serious issue with work_mem, no? -- Josh Berkus PostgreSQL @ Sun San Francisco