postgis vs sphinx geodist

Question

I have a table with 16 mln rows. Cities, streets, houses with their coordinates.

How best to search for objects, knowing their coordinates? PostGis or the Sphinx with GeoDist function?

Now I am using a Sphinx, but there is a question the relevance of the data as well as an update of all the index takes more than 4 hours, and indexing delta with following merge main takes about 10 minutes.

Answer 1

Mainly it depends on other features you require. For example if using the text query functionality of sphinx, then stick with it.

But if not using that anyway, and can benefit of other features of postgis, then change to that.

indexing delta with following merge main

Why merge?

Skip the merge, and just query both indexes.