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.
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
