Re: [PERFORM] Improve Seq scan performance

2008-11-10 Thread Lutischán Ferenc
Dear Vladimir, Thanks for clear description of the problem. :-) Please report it to the bug list. I hope it will be accepted as a "performance bug" and will be solved. Best Regards, Ferenc Vladimir Sitnikov wrotte: As far as I understand, it is discouraged to implement/suggest patches dur

[PERFORM] Improve Seq scan performance

2008-11-09 Thread Lutischán Ferenc
Dear List, I would like to improve seq scan performance. :-) I have many cols in a table. I use only 1 col for search on it. It is indexed with btree with text_pattern_ops. The search method is: r like '%aaa%' When I make another table with only this col values, the search time is better wh