union all over union - Githubissues

minus34 / gnaf-loader

A quick way to get started with Geoscape's open GNAF & Admin Boundaries

Apache License 2.0

182 stars 66 forks source link

union all over union #66

Closed tjmcewan closed 2 years ago

tjmcewan commented 2 years ago

The addresses views in the GNAF files use a UNION which seems to cause Postgres to check for duplicates before displaying data. As the addresses are unique anyway, could you pretty please change the definition to UNION ALL so the data is displayed immediately? 🙏

Totally understand if there's a reason not to.

Thanks again for this wonderful service!

minus34 commented 2 years ago

Good call. fixed in commit #46c9b5a

tjmcewan commented 2 years ago

Awesome, thanks! 🙇🏻