Answer the question
In order to leave comments, you need to log in
Postgis vs Sphinx. What is better to use for searching by coordinates?
There is a table of addresses on 16 million records. Taken from FIAS. In one table there are cities, streets and houses. I ran through all the records with the Yandex geocoder, put down the coordinates.
And the actual question. What is the best way to search for objects now, knowing their coordinates? Postgis or Sphinx?
Now the geo table is in Sphinxe, the search is carried out through GeoDIST , however, the question of data relevance arises, since updating the entire index takes more than 4 hours, and delta indexing and subsequent merge take about 10 minutes.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question