Having worked on an ingestion pipeline for geospatial data I’d say postgis is more than ok (and possibly an industry leader) for those kinds of queries. There’

Having worked on an ingestion pipeline for geospatial data I’d say postgis is more than ok (and possibly an industry leader) for those kinds of queries. There’s other “big data” DB’s like Cassandra or Elastic that can handle GIS data but I’m skeptical they are even necessary until you reach petabytes of data. Having a solid indexing strategy will basically fulfil the majority of your performance concerns. Things like simplifying geometry, reducing scans etc