[Tile-serving] [openstreetmap/osm2pgsql] From the docs: Array elements can be a sign of database misdesign (#879)

[FranklinClinton]

I have importet OSM data with the following command:
osm2pgsql --create --slim -C 2000 --hstore --latlong germany-filtered.osm
Imprt was successfull, however I noticed a strange database scheme:
`SELECT * FROM planet_osm_ways LIMIT 2;
id | nodes | text
92 | {442734,442735,308149691,442736,4665821726,442737,4665821727,442738,442739,2429178447,442740} | {name,Eigenheimstraße,highway,residential,maxspeed,30}` 

In the docs of postgresql it says the following:
> Tip: Arrays are not sets; searching for specific array elements can be a sign of database misdesign. Consider using a separate table with a row for each item that would be an array element. This will be easier to search, and is likely to scale better for a large number of elements.

So I was wondering if I did something wrong.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/879
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20181031/1eaa56aa/attachment.html>