Re: [PERFORM] Improve Seq scan performance

2008-11-09 Thread Vladimir Sitnikov
> Lutischán Ferenc wrote: > > It is possible to make an index on the table, and make a seq index scan on >> this values? >> > > My understanding is that this isn't possible in PostgreSQL, because indexes > do not contain information about tuple visibility. Data read from the index > might refer to

Re: [PERFORM] Improve Seq scan performance

2008-11-09 Thread Craig Ringer
Lutischán Ferenc wrote: It is possible to make an index on the table, and make a seq index scan on this values? My understanding is that this isn't possible in PostgreSQL, because indexes do not contain information about tuple visibility. Data read from the index might refer to tuples that'v

[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