[OSM-dev] Is there a way to use simple schema without hstore
brfr at metrico.lu
Thu Nov 18 13:00:16 GMT 2010
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?
> dev mailing list
> dev at openstreetmap.org
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 ;-)
More information about the dev