NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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's gravatar image

JamesPep
16223
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×165
×9
×2

question asked: 16 Jun '22, 10:36

question was seen: 988 times

last updated: 16 Jun '22, 10:36

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum