[OSM-dev] Is there a way to use simple schema without hstore

Sven Geggus lists at fuchsschwanzdomain.de
Fri Nov 19 10:03:31 GMT 2010


Andreas Kalsch <andreaskalsch at gmx.de> wrote:

> Example for unnessessary complex schema design: 
> http://wiki.openstreetmap.org/wiki/DE:HowTo_minutely_hstore

You are welcome to design a better database scheme suitable for rendering :)

osm2pgsql output is evolution _not_ design.

Using a join in every single SQL request is not an Option in this case at
least performancewise.

> Probably I am wrong ... yes I know that you can index hstore with a GIST.

GIN

Sven

-- 
Threading is a performance hack.
(The Art of Unix Programming by Eric S. Raymond)

/me is giggls at ircnet, http://sven.gegg.us/ on the Web



More information about the dev mailing list