address_detail_flat creation taking many hours to create

ondrejivanic / G-NAF

Geocoded National Address File is Australia’s authoritative, geocoded address file. This repo has few tools / scripts to create derived datasets

Apache License 2.0

20 stars 7 forks source link

address_detail_flat creation taking many hours to create #3

Closed gitdlam closed 6 years ago

gitdlam commented 6 years ago

Hello, wondering what's a rough estimate of time it should take for the creation of this table. It's been about 24 hours so far, so i'm wondering if it's my problem or is it expected to take so long.

I'm using probably "average" hardware, a laptop with 8G ram with Intel i7-6600U cpu.

gitdlam commented 6 years ago

Okay now. I just had to create indices on the tables on the right hand side. Took 5 minutes after that.