You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I've found a few duplicated rows in the planet_osm_roads table on one of the world databases.
This database is quite old, and has been updated using diff for several years.
They all happened on geometries originating from relations (boundaries, etc).
I've not yet checked the line and polygon tables.
I discovered that by trying to create a unique index on these tables in order to be able to use pg_repack to vacuum/cluster these tables without global lock.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
I've found a few duplicated rows in the planet_osm_roads table on one of the world databases.
This database is quite old, and has been updated using diff for several years.
They all happened on geometries originating from relations (boundaries, etc).
I've not yet checked the line and polygon tables.
I discovered that by trying to create a unique index on these tables in order to be able to use pg_repack to vacuum/cluster these tables without global lock.
Beta Was this translation helpful? Give feedback.
All reactions