Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D72769FB1E4 for ; Fri, 19 Jan 2007 02:15:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 55987-03 for ; Fri, 19 Jan 2007 02:15:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from olive.qinip.net (olive.qinip.net [62.100.30.40]) by postgresql.org (Postfix) with ESMTP id 851D19F9A8D for ; Fri, 19 Jan 2007 02:15:15 -0400 (AST) Received: from [127.0.0.1] (h8441139206.dsl.speedlinq.nl [84.41.139.206]) by olive.qinip.net (Postfix) with ESMTP id 45174180AB; Fri, 19 Jan 2007 07:15:10 +0100 (MET) Message-ID: <45B061F0.6040309@tweakers.net> Date: Fri, 19 Jan 2007 07:15:12 +0100 From: Arjen van der Meijden User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Tom Lane CC: pgsql-performance@postgresql.org Subject: Re: Configuration Advice References: <090501c73a90$7f154330$6400a8c0@dualcore> <45AF4ACA.5060805@tweakers.net> <1169141307.10693.1169947257@webmail.messagingengine.com> <45AFE234.70301@tweakers.net> <6826.1169158297@sss.pgh.pa.us> In-Reply-To: <6826.1169158297@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0704-0, 18-01-2007), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/329 X-Sequence-Number: 22930 On 18-1-2007 23:11 Tom Lane wrote: > Increase work_mem? It's not taking the hash because it thinks it won't > fit in memory ... When I increase it to 128MB in the session (arbitrarily selected relatively large value) it indeed has the other plan. Best regards, Arjen