[GENERAL] Performance Issues (was: like vs substring again)

2007-09-18 Thread Christian Schröder
Hi list, I am still fighting with the really slow database queries (see http://www.nabble.com/%22like%22-vs-%22substring%22-again-t4447906.html), and I still believe that the cause of the problem is that the query planner makes incorrect estimations about the selectivity of the where clauses.

Re: [GENERAL] Performance Issues (was: like vs substring again)

2007-09-18 Thread John D. Burger
Christian Schröder wrote: Or would it be possible to tweak how the planner determines the selectivity? I have read in the docs (chapter 54.1) that in case of more than one condition in the where clause, independency is assumed. In my case (... where test like '11%' and test not like