Re: Request to help on GIS Query improvement suggestion. - Mailing list pgsql-admin

From Michael Lewis
Subject Re: Request to help on GIS Query improvement suggestion.
Date
Msg-id CAHOFxGrhV7H9gqGnTqRJauVh__q=EGKCkC_RVqbamG49x_Ppcw@mail.gmail.com
Whole thread Raw
In response to Request to help on GIS Query improvement suggestion.  (postggen2020 s <postggen2020@gmail.com>)
List pgsql-admin
Your indexes and operators are not compatible. You have added a btree index on md5 function result and are not using md5 in your query, and also using LIKE operator not one of the supported ones. I believe it might use a btree operator (plain value, not md5 result) if you are always searching for "string starts with ____ but I don't know what it ends with" but you can't possibly use a btree index where you are putting a wild card at the front.


a gist index operators supported-

Here's a whole page on full text search, it would be worth a read-

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Lag clarification with Sync Replication
Next
From: Keith
Date:
Subject: Re: Lag clarification with Sync Replication