> Tom Lane wrote: > > Instead, I'm thinking it might be time to re-introduce some notion of > > function execution cost into the system, and make use of that info to > > sort WHERE clauses into a reasonable execution order.
I imagine you've thought of this already but just in case, the cost of the function call has to be combined with the selectivity to get this right. If you can do an expensive but very selective clause first and save 100 cheap calls that almost always return true it may still be worthwhile. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org