3 ms·
SELECT address, name, position, population, security, government, allegiance, primary_economy,
by nixpulvis 6y ago
SELECT
address,
name,
position,
population,
security,
government,
allegiance,
primary_economy,
secondary_economy,
updated_at
FROM systems
WHERE ST_3DDWithin(position, $1, $2);
With the aforementioned index:
"systems_position_idx" gist ("position" gist_geometry_ops_nd)
- yxhuvud 6y agoOk, I see no obvious ways that is suboptimal. I assume there are no difference if you switch places of position and $1?