I'm sorry, I realized after posting this that it went to the wrong
list, I resent it to pgsql-sql instead.
But basically I haven't done any ANALYZE or EXPLAIN yet because of the
fact that the order -is- making a difference so it can't be executing
the same query inside the database engine. Given that, I figured I would
jsut look for theories on how to rewrite the queries before submitting first.
btw, we are using postgresql 7.1.2 compiled from source on rh linux 7.0.
I also might not have been very clear about the fact that the user is
basically constructing the query dynamically in the application, so it's
not a matter of just optimizing any specifc query, but any possible query.
Tom Lane [tgl@sss.pgh.pa.us] wrote:
> Dav Coleman <dav@serve.com> writes:
> > I have noticed that the semantically equivalent SQL queries can
> > differ
> > vastly in speed performance depending on the order of clauses ANDed
> > together ( "WHERE cond1 AND cond2" takes forever, but "WHERE cond2
> > AND cond1" comes right back).
>
> Could we see a specific example?
>
> It would also be useful to know what PG version you are using, whether
> you've VACUUM ANALYZEd the tables, and what EXPLAIN has to say about
> your query.
>
> regards, tom lane
--
Dav Coleman
http://www.danger-island.com/dav/
--
Dav Coleman
http://www.danger-island.com/dav/