For spatial indexing of obscore table we need pg_sphere extension enabled. Standard postgres deployment usually comes without that extension, so it has to be installed separately. Details for that process depend on how postgres is deployed. Some Linux distributions may have that extension in their repos, and also Postgres has it in its repos as well.
I think we need that for USDF and also for cloud instance, likely very different approaches needed for those two cases.