Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
nicois
on April 5, 2021
|
parent
|
context
|
favorite
| on:
PostGIS – Spatial and Geographic Objects for Postg...
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.
cwmma
on April 5, 2021
[–]
assuming you're using the postgis spatial data types (and not the postgres ones) it'll take care of that automatically.
nixpulvis
on April 5, 2021
|
parent
[–]
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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
