Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6B9E12E00A5 for ; Sun, 1 Jun 2008 06:08:04 -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 49098-04 for ; Sun, 1 Jun 2008 06:07:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137094.authsmtp.co.uk (outmail137094.authsmtp.co.uk [62.13.137.94]) by developer.postgresql.org (Postfix) with ESMTP id 8EC812E00A0 for ; Sun, 1 Jun 2008 06:08:00 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt4.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5197rLh030188; Sun, 1 Jun 2008 10:07:53 +0100 (BST) Received: from [192.168.0.3] (85-211-65-92.dyn.gotadsl.co.uk [85.211.65.92]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5197q3E060799; Sun, 1 Jun 2008 10:07:52 +0100 (BST) Subject: Re: 2GB or not 2GB From: Simon Riggs To: Josh Berkus Cc: pgsql-performance@postgresql.org In-Reply-To: <200805311153.13186.josh@agliodbs.com> References: <200805281659.26945.josh@agliodbs.com> <1212219897.4120.195.camel@ebony.site> <200805311153.13186.josh@agliodbs.com> Content-Type: text/plain Date: Sun, 01 Jun 2008 10:10:40 +0100 Message-Id: <1212311440.4120.235.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 375395d6-2fba-11dd-aecc-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaARbZ0xf HGQLW1xEUV17WWR/ bggfZQBDYEtPQQNv TkFLXVBXFgB3AVJc Ax8XVVhxAgVAeHl5 bAhjX3VSEkd9cEV0 RxpSCG9QNzZ9aWFL BF0JIlAHbQNKfxdC awV2V3NbZStlM3Bw LDceBR4WBxBqYH56 aEkKNxoURlpDRBEW L2Fs X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:1045/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/1 X-Sequence-Number: 30351 On Sat, 2008-05-31 at 11:53 -0700, Josh Berkus wrote: > 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? Depends upon your view of serious I suppose. I would say it is an acceptable situation, but needs further optimization. I threw some ideas around on Hackers around Dec/New Year, but I don't have time to work on this further myself in this dev cycle. Further contributions welcome. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support