4 ms·
If you're at the limits of "scaling up" in PostGIS you could look into "scaling out" by migrating to a NoSQL solution like Cassandra or HBase + GeoMesa[1]. Howe
by alexhutcheson 7y ago
If you're at the limits of "scaling up" in PostGIS you could look into "scaling out" by migrating to a NoSQL solution like Cassandra or HBase + GeoMesa[1]. However, this would be a pretty significant change and introduces a lot of new operational burden, so I wouldn't do it unless you think you can't meet your goals with PostGIS.
I think a good first step would be bringing in a PostGIS consultant who can give you some expert advice on tuning for your current workload.
[1] https://github.com/locationtech/geomesa https://github.com/locationtech/geomesa
- durkie 7y agoI appreciate it! Postgis I think is still quite good, it's just computationally intense for some operations (which I suspect geomesa might run in to as well -- I think a lot of gis libraries make use of gdal and proj libraries under the hood)