X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9A5DA7E5 for ; Thu, 20 Oct 2005 01:58:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75888-04 for ; Thu, 20 Oct 2005 04:58:54 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3D5BBDA7A3 for ; Thu, 20 Oct 2005 01:58:54 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9K4wp7w004453; Thu, 20 Oct 2005 00:58:51 -0400 (EDT) To: "Steinar H. Gunderson" Cc: pgsql-performance@postgresql.org Subject: Re: Materializing a sequential scan In-reply-to: <20051019174544.GA32303@samfundet.no> References: <20051019174544.GA32303@samfundet.no> Comments: In-reply-to "Steinar H. Gunderson" message dated "Wed, 19 Oct 2005 19:45:44 +0200" Date: Thu, 20 Oct 2005 00:58:51 -0400 Message-ID: <4452.1129784331@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/273 X-Sequence-Number: 15041 "Steinar H. Gunderson" writes: > BEGIN > INSERT INTO kortsys2.mdb_gruppekobling_temp > SELECT overgruppe_id,undergruppe_id FROM gruppekobling gk > JOIN gruppe g1 ON gk.overgruppe_id=g1.gruppe_id > JOIN gruppe g2 ON gk.overgruppe_id=g2.gruppe_id > WHERE g1.aktiv AND g2.aktiv; > LOOP BTW, it sure looks like that second JOIN ought to be JOIN gruppe g2 ON gk.undergruppe_id=g2.gruppe_id As-is, it's not doing anything for you ... certainly not enforcing that the undergruppe_id be aktiv. regards, tom lane