Hello.
If I have a table like this
create table fleet ( ship_id integer, location point);
and fill it with a lot of ships and their locations and then want to
create an index on this to speed up operations on finding ships within
a certain region (let's say its a rectangular region), how do I do
this?
I tried:
CREATE INDEX my_index ON fleet USING gist ( box(location,location)); ?
and that command worked, but I have no idea why and what I have just
done. The docs are a little to advanced.
How should one do it?