[OSM-dev] Questions on PostGIS

[Artem Pavlenko]

>>
>>
> This is indeed an issue with the datastructure from OSM. Building
> queries to combine nodes to dynamically generate ways on every request
> is a performance killer!
> Basically I think it would be best to write a script that will  
> generate
> REAL ways (polylines) in the postGIS database in a real geometric  
> table.
> That way you will take optimized use of geometry functions.


Where have you been? Do you read this mailing list  or wiki ? ;)

__osm2pgsql__

http://trac.openstreetmap.org/browser/applications/utils/export/ 
osm2pgsql

Cheers
Artem