3 ms·
> 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. Doesn't that sou
by jhgb 6y ago
> 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.
Doesn't that sound a bit pathological? It should be nowhere near that slow. Try implementing a VP tree over that data.
- nixpulvis 6y agoI mean, I'm using the provided GiST-based R-Tree spatial index... Otherwise, I'm not really making any use of PostGIS and might as well look for other spacial DBs or write my own little data-structure like you mention (thanks for the link to VP-trees btw). I was hoping that the performance of PostGIS's features could be improved with some know how.