What indexes are generated in 1.6?
my import failed (again. do NOT trust AWS RDS Aurora Postgresql serverless!) during index creation, and was wondering what were necessary to finish the installation.
Completed planet_osm_point
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels
Stopped table: planet_osm_rels in 634s
Copying planet_osm_line to cluster by geometry finished
Creating geometry index on planet_osm_line
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
Another user stated that, for 1.4 the indexes needed could likely be completed with:
CREATE INDEX planet_osm_line_osm_id_idx ON public.planet_osm_line USING btree (osm_id);
CREATE INDEX planet_osm_line_way_idx ON public.planet_osm_line USING gist (way);
CREATE INDEX planet_osm_point_osm_id_idx ON public.planet_osm_point USING btree (osm_id);
CREATE INDEX planet_osm_point_way_idx ON public.planet_osm_point USING gist (way);
CREATE INDEX planet_osm_polygon_osm_id_idx ON public.planet_osm_polygon USING btree (osm_id);
CREATE INDEX planet_osm_polygon_way_idx ON public.planet_osm_polygon USING gist (way);
CREATE INDEX planet_osm_rels_parts_idx ON public.planet_osm_rels USING gin (parts) WITH (fastupdate=off);
CREATE INDEX planet_osm_roads_osm_id_idx ON public.planet_osm_roads USING btree (osm_id);
CREATE INDEX planet_osm_roads_way_idx ON public.planet_osm_roads USING gist (way);
CREATE INDEX planet_osm_ways_nodes_idx ON public.planet_osm_ways USING gin (nodes) WITH (fastupdate=off);
I was wondering/hoping that this was still true with 1.6 and/or someone had an updated list available
asked
16 Jun '22, 10:36
JamesPep
16●2●2●3
accept rate:
0%