Tieson Molly <tvm...@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
