X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E598ED1D453 for ; Mon, 24 Nov 2003 19:30:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14012-02 for ; Mon, 24 Nov 2003 15:30:04 -0400 (AST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id C6FE9D1D643 for ; Mon, 24 Nov 2003 15:29:45 -0400 (AST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1AOMP2-000DtI-0Z; Mon, 24 Nov 2003 19:29:44 +0000 Received: by mainbox.archonet.com (Postfix, from userid 529) id 90E4C17CEC; Mon, 24 Nov 2003 19:29:42 +0000 (GMT) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id EBF861622E; Mon, 24 Nov 2003 19:29:40 +0000 (GMT) From: Richard Huxton To: stephen farrell , pgsql-performance@postgresql.org Subject: Re: Problem with insert into select... Date: Mon, 24 Nov 2003 19:29:40 +0000 User-Agent: KMail/1.5 References: <3FBD2C5D.8000706@almaden.ibm.com> In-Reply-To: <3FBD2C5D.8000706@almaden.ibm.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200311241929.40600.dev@archonet.com> X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/223 X-Sequence-Number: 4783 On Thursday 20 November 2003 21:04, stephen farrell wrote: > I'm having a problem with a queyr like: INSERT INTO FACT (x,x,x,x,x,x) > SELECT a.key,b.key,c.key,d.key,e.key,f.key from x,a,b,c,d,e,f where x=a > and x=b .... -- postgres7.4 is running out of memory. When this has happened to me it's always been because I've got an unconstrained join due to pilot error. Try an EXPLAIN on the select part and see if that pops up anything. -- Richard Huxton Archonet Ltd