Re: Help optimize view - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Help optimize view
Date
Msg-id 46C7528E.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Help optimize view  ("Relyea, Mike" <Mike.Relyea@xerox.com>)
List pgsql-performance
>>> On Fri, Aug 10, 2007 at 11:57 AM, in message
<1806D1F73FCB7F439F2C842EE0627B18065BEC18@usa0300ms01.na.xerox.net>, "Relyea,
Mike" <Mike.Relyea@xerox.com> wrote:
> HAVING "PrintSamples"."MachineID" = 4741 OR "PrintSamples"."MachineID" =
> 4745 AND . . .

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.

-Kevin




pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Help optimize view
Next
From: "mark overmeer"
Date:
Subject: schema design question