Tieson Molly <tvmaly@xxxxxxxxx> writes: > is there a different construct than the Similar To that would work? > I know for certain that the first few characters could be different due to > the nature of geohashes. So I may not be able to optimize the prefix > aspect in some cases. Depending on what patterns you're looking for, it's possible that a trigram index (contrib/pg_trgm) would work better. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
