PostGIS – Spatial and Geographic Objects for PostgreSQL
I've been using PostGIS a bit for a toy project with Elite: Dangerous star system data. It's been a hoot, but I do worry that I'm going to start having trouble optimizing my queries. Finding all the systems within say 20 Ly of our sun can take upwards of a few seconds, and I've already added a GIST index on the positions.<p>I also find it a bit strange how 3D feels kinda tacked on, but it makes sense when you realize most maps are in fact 2D.<p>Anyway, my 2-cents of experience. If anyone has some good advise for > million row, 3D spacial optimizations for PostGIS, please let me know.