Y
Hacker News
new
|
ask
|
show
|
jobs
by
nicois
1894 days ago
Is it possible you haven't added the bounding box for your geometries? The GIST index will use your bounding box to optimise the queries, but only if it finds one. Also make sure your query is actually using the index.
1 comments
cwmma
1894 days ago
assuming you're using the postgis spatial data types (and not the postgres ones) it'll take care of that automatically.
link
nixpulvis
1894 days ago
Yes, I'm currently just using a single PointZ column, which is at least making some use of the index on my relevant 3DDWithin queries.
link