rustprooflabs / pgosm-flex

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS (Postgres) using the osm2pgsql Flex output.
MIT License
101 stars 20 forks source link

Deleting member rows that duplicate relation instead of creating MVs … #257

Closed rustprooflabs closed 2 years ago

rustprooflabs commented 2 years ago

This PR changes the approach of de-duplication of relations/members to actually delete the duplicate rows instead of creating an MV that removed the duplication.

The approach of creating materialized views with a handful fewer rows to remove duplication didn't seem very logical. The net effect was basically duplicating the data size in the process, adding more layers via #256 made this pretty apparent with the road / waterway layers.