X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 64BB8D1F11A for ; Tue, 20 Apr 2004 20:34:41 -0300 (ADT) 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 55788-07 for ; Tue, 20 Apr 2004 20:34:39 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CEB66D1FB10 for ; Tue, 20 Apr 2004 18:58:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3KLwV2M022628; Tue, 20 Apr 2004 17:58:31 -0400 (EDT) To: "Chris Hoover" Cc: pgsql-performance@postgresql.org Subject: Re: Use of subquery causes seq scan??? In-reply-to: <200404201020.05699.revoohc@sermonaudio.com> References: <200404151248.16067.jeremy.guthrie@berbee.com> <200404201020.05699.revoohc@sermonaudio.com> Comments: In-reply-to "Chris Hoover" message dated "Tue, 20 Apr 2004 10:20:05 -0400" Date: Tue, 20 Apr 2004 17:58:31 -0400 Message-ID: <22627.1082498311@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/310 X-Sequence-Number: 6610 "Chris Hoover" writes: > Select * > from table a > where inv_num in (select inv_num from table b where ....) > I'm running 7.3.4 on RedHat EL 2.1. IN (SELECT) constructs pretty well suck in PG releases before 7.4. Update, or consult the FAQ about rewriting into an EXISTS form. regards, tom lane