Some of the data sources of interest for location-based applications generate tens of millions of updates per second. I love PostgreSQL but it does not operate at that scale. The index locking alone would kill it even if you weren't touching disk.

Extremely high spatial ingest rates concurrent with queries requires different architecture and algorithms.