X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B4FD1476164 for ; Tue, 13 May 2003 15:30:46 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id F3796475AA9 for ; Tue, 13 May 2003 15:30:45 -0400 (EDT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3031126; Tue, 13 May 2003 12:30:48 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Adam Sherman , pgsql-sql@postgresql.org Subject: Re: Locating all Children given Set of Parents Date: Tue, 13 May 2003 12:30:17 -0700 User-Agent: KMail/1.4.3 References: <184690000.1052842782@saturn> <200305131201.45493.josh@agliodbs.com> <202340000.1052853543@saturn> In-Reply-To: <202340000.1052853543@saturn> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200305131230.17724.josh@agliodbs.com> X-Spam-Status: No, hits=-22.7 required=5.0 tests=BAYES_01,IN_REP_TO,REFERENCES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/238 X-Sequence-Number: 13403 Adam, > Oh? I just did, and it worked fine. I take it this is a performance issue? Yes. If you use "SELECT *" in a WHERE EXISTS clause, you may cause the sys= tem=20 to use more sort resources than are really necessary, especially if you hav= e=20 TOASTed or LO columns in the table. --=20 -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco