Any performance penalties for PostGIS queries? #1110
-
My current app extensively uses PostGIS for proximity search, especially to only return search results within a given distance or within a given city, postcode area or state. The docs state that filters should be done within Cheers! |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 6 replies
-
To get the best search performance, you should leverage Is it possible to try something like adding the coordinates of your results to the index as |
Beta Was this translation helpful? Give feedback.
There's not really a way to perform a search query across a reduced dataset, such as with a CTE. You're always searching over your search index.
You don't need to interact with Tantivy directly. I suggest you try to add
lat
andlong
asnumeric_fields
on when youcreate_bm25
, that would let you query them like this:https://docs.paradedb.com/search/full-text/bm25#efficient-filtering