[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