Re: Help optimize view

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>, "Mike Relyea" <Mike(dot)Relyea(at)xerox(dot)com>
Subject: Re: Help optimize view
Date: 2007-08-19 01:11:59
Message-ID: 46C7528E.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> On Fri, Aug 10, 2007 at 11:57 AM, in message
<1806D1F73FCB7F439F2C842EE0627B18065BEC18(at)usa0300ms01(dot)na(dot)xerox(dot)net>, "Relyea,
Mike" <Mike(dot)Relyea(at)xerox(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mark overmeer 2007-08-19 13:19:52 schema design question
Previous Message Kevin Grittner 2007-08-19 01:01:50 Re: Help optimize view