Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 217319F9856
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 18 Aug 2007 22:12:08 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 55727-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 18 Aug 2007 22:12:05 -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 90AE19F9827
	for <pgsql-performance@postgresql.org>;
	Sat, 18 Aug 2007 22:12:05 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Sat, 18 Aug 2007 20:12:04 -0500
Message-Id: <46C7528E.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Sat, 18 Aug 2007 20:11:59 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-performance@postgresql.org>, "Mike Relyea" <Mike.Relyea@xerox.com>
Subject: Re: Help optimize view
References: 
 <1806D1F73FCB7F439F2C842EE0627B18065BEC18@usa0300ms01.na.xerox.net>
In-Reply-To: 
 <1806D1F73FCB7F439F2C842EE0627B18065BEC18@usa0300ms01.na.xerox.net>
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/192
X-Sequence-Number: 26322

>>> On Fri, Aug 10, 2007 at 11:57 AM, in message
<1806D1F73FCB7F439F2C842EE0627B18065BEC18@usa0300ms01.na.xerox.net>, =
"Relyea,
Mike" <Mike.Relyea@xerox.com> wrote:=20
> HAVING "PrintSamples"."MachineID" =3D 4741 OR "PrintSamples"."MachineID" =
=3D
> 4745 AND . . .
=20
On top of the issue in my prior email, I don't see any test for 4745 in =
the
EXPLAIN ANALYZE output, which makes me think it doesn't go with the posted
query.
=20
-Kevin
=20