Re: [PERFORM] tsearch2 question (was: Poor performance on seq

2006-09-12 Thread Luke Lonergan
Lazlo, On 9/12/06 10:01 AM, "Laszlo Nagy" <[EMAIL PROTECTED]> wrote: > zeusd1=> explain analyze select id from product_search where name_desc > like '%Mug%'; >QUERY PLAN > -

[PERFORM] tsearch2 question (was: Poor performance on seq scan)

2006-09-12 Thread Laszlo Nagy
Tom Lane wrote: Only if the index is capable of disgorging the original value of the indexed column, a fact not in evidence in general (counterexample: polygons indexed by their bounding boxes in an r-tree). But yeah, it's interesting to think about applying filters at the index fetch step for i