Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] substring index what is better way to query - Mailing list pgsql-performance

From Tom Lane
Subject Re: [PERFORM] substring index what is better way to query
Date
Msg-id 3969.1497969947@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] substring index what is better way to query  (Tieson Molly <tvmaly@gmail.com>)
List pgsql-performance
Tree view 
Tieson Molly <tvmaly@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

pgsql-performance by date:

Previous
From: Tieson Molly
Date:
Subject: Re: [PERFORM] substring index what is better way to query
Next
From: Sumeet Shukla
Date:
Subject: [PERFORM] Dataset is fetched from cache but still takes same time to fetchrecords as first run