Create spatial indexes for OSMM ITN
CREATE INDEX ferrylink_geom_idx ON itn.ferrylink USING GIST (wkb_geometry);
COMMIT;
CREATE INDEX ferrynode_geom_idx ON itn.ferrynode USING GIST (wkb_geometry);
COMMIT;
CREATE INDEX infopoint_geom_idx ON itn.informationpoint USING GIST (wkb_geometry);
COMMIT;
CREATE INDEX roadlink_geom_idx ON itn.roadlink USING GIST (wkb_geometry);
COMMIT;
CREATE INDEX roadlinkinfo_geom_idx ON itn.roadlinkinformation USING GIST (wkb_geometry);
COMMIT;
INDEX roadnode_geom_idx ON itn.roadnode USING GIST (wkb_geometry);
COMMIT;
Updated less than a minute ago