Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 18 Aug 2007 20:11:59 -0500
>>> 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
- References:
- Help optimize view
- From: Relyea, Mike
- Help optimize view
- Prev by Date: Re: Help optimize view
- Next by Date: schema design question
- Previous by thread: Re: Help optimize view
- Next by thread: Re: Help optimize view
- Indexes: