[osmosis-dev] nodes column in way table and way_nodes table

[Michel Seuthe]

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