On Feb 11, 2008, at 10:37 AM, Mario Lopez wrote:
> The problem arises with the second type of queries, where there are
> no possible partitions and that the search keywords are not known, I
> have tried making indexes on the letter it ends with, or indexes
> that specify that it contains the letter specified but none of them
> work the planifier only make sequential scans over the table.
Postgres doesn't use indexes on prefix-wildcard searches like your
'%word' type search. It will always sequential scan the table.
