Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 5A7619F9CA6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 22 Aug 2007 15:50:50 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 60712-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 22 Aug 2007 15:50:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 7C4CF9F9C1B
	for <pgsql-performance@postgresql.org>;
	Wed, 22 Aug 2007 15:50:46 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Wed, 22 Aug 2007 13:50:45 -0500
Message-Id: <46CC3F22.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Wed, 22 Aug 2007 13:50:26 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-performance@postgresql.org>,
	"Stephen Davies" <scldad@sdc.com.au>
Subject: Re: Optimising "in" queries
References: <200708221210.36770.scldad@sdc.com.au>
In-Reply-To: <200708221210.36770.scldad@sdc.com.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/245
X-Sequence-Number: 26375

>>> On Tue, Aug 21, 2007 at  9:40 PM, in message
<200708221210.36770.scldad@sdc.com.au>, Stephen Davies <scldad@sdc.com.au>
wrote:=20
> Is there any way to make the "larger" queries more efficient?
=20
People would be in a better position to answer that if you posted the =
table
structure and the results of EXPLAIN ANALYZE (rather than just EXPLAIN).
=20
-Kevin