So, I have a view. The query that the view uses can be written two different ways, to use two different indexes. Then I use the view in another query, under some circumstances the first way will be quick, and under other circumstances the second way will be quick.

What I want to know is, can I create a view that has both queries, and allows the planner to choose which one to use? The documentation seems to say so in http://www.postgresql.org/docs/8.3/interactive/querytree.html (the rule system "creates zero or more query trees as result"), but doesn't say how one would do it.

Matthew

--
I have an inferiority complex. But it's not a very good one.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to