I have a table with varchar and text columns, and I have to search through
these text in the whole table.
An example would be:
SELECT * FROM table
WHERE name like '%john%' or street like '%srt%'
Anyway, the query planner always does seq scan on the whole table and that
takes some time. How can this be optimized or made in another way to be
I tried to make indexes on the columns but no success.
pgsql-performance by date
|Next:||From: Vivek Khera||Date: 2007-05-23 15:47:27|
|Subject: Re: performance drop on 8.2.4, reverting to 8.1.4|
|Previous:||From: Tom Lane||Date: 2007-05-23 14:01:06|
|Subject: Re: does VACUUM ANALYZE complete with this error? |