Recreating index on planet_osm_nodes

Question

It appears that I have corrupted / overwrote the index planet_osm_nodes for my Open Street Map installation.  I would like to recreate it, but am not sure of the access method (b-tree, GIST...) which osm2pgsql initially created it as.  I am using postgres.

I have tried this:

create index planet_osm_nodes on public.planet_osm_nodes USING gist (id)

But get errors

Can anyone let me know how best to recreate this index?

JGH · Answer

The nodes.id is a primary key build using the default btree index type. (it's from the code).

That being said, if you want to drop/recreate the primary key, you would also have to take note and recreate the foreign keys.

Recreating index on planet_osm_nodes

One Answer

Add your own answers!

Ask a Question