Hi -
I have a table of about 3 million rows of city "aliases" that I need
to query using LIKE - for example:
select * from city_alias where city_name like '%FRANCISCO'
When I do an EXPLAIN ANALYZE on the above query, the result is:
Seq Scan on city_alias (cost=0.00..59282.31 rows=2 width
your query. Read http://www.sai.msu.su/~megera/postgres/gist/
pg_trgm/README.pg_trgm
for more details.
Oleg
On Sun, 29 May 2005, Michael Engelhart wrote:
Hi -
I have a table of about 3 million rows of city "aliases" that I
need to query using LIKE - for example:
select * f