No Problem Igor.
I was just confused by this fact. I expected more, but the table would just be
about 26gb big if you import the full planet.osm. So it should be no problem.
Thanks anyways.
Happy Holidays.
Am 21.12.2011 um 15:55 schrieb Igor Podolskiy:
> Hi Michel,
>
>> For example:
>>
>> SELECT id, nodes FROM ways WHERE id=55579416;
>> delivers:
>> 55579416; "{299810549,299809848,299810550,259983366}"
>>
>>
>> SELECT way_id, node_id, sequence_id FROM way_nodes WHERE way_id=55579416;
>> delivers:
>> 55579416;299810549;0
>> 55579416;299809848;1
>> 55579416;299810550;2
>> 55579416;259983366;3
> hmm, indeed, I overlooked that, sorry. I don't know the reason why it is
> stored twice... Apparently it has been added to avoid joins for some common
> operations (see commit 6a507fa, [1]). So you're right, it is stored
> redundantly. Sorry again for the confusion.
>
> Bye
> Igor
>
> [1]
> https://github.com/openstreetmap/osmosis/commit/6a507faca5a5c902ce6a24554fae467d79910bc0
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
