Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA12250 for ; Mon, 1 Nov 1999 17:11:48 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id RAA02750; Mon, 1 Nov 1999 17:10:28 -0500 (EST) To: Oskar Liljeblad cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] query with subquery abnormally slow? In-reply-to: Your message of Mon, 1 Nov 1999 19:47:07 +0100 <19991101194707.A7034@oskar> Date: Mon, 01 Nov 1999 17:10:28 -0500 Message-ID: <2748.941494228@sss.pgh.pa.us> From: Tom Lane Oskar Liljeblad writes: > I'm doing a SELECT query with a subquery on a table with 12K rows > but it is very slow (10 seconds+). The query looks like this: > select * > from items > where package in > (select package > from items > where ...blah... > group by package) Have you considered something like select i1.* from items i1, items i2 where i1.package = i2.package and i2.performer ~ '...'; This would only be fast given an index on package, I think, but you said you had one... regards, tom lane