Am 18.11.2010 10:18, schrieb Andreas Kalsch:
Is there a way to use simple schema in Osmosis without hstore? And why
was this changed? A separate table for tags can more easily be indexed.
I think it is not a good idea to use hstore because then we can drop
SQL, use NoSQL for storing data and use PostGIS/Postgres for Geometry only.
What do you think?
Best,
Andi
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
Hello Andi,
You can create an index for the tags column. hstore supports gist and
gin indexes and plus it saves you a m:n join. And I don't see why using
hstore data type is like using NoSQL? You can still extract the tags
into a seperate table, if you like of course ;-)
Frank
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
