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

Frank Broniewski 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?
> Best,
>
> Andi
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> 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



More information about the dev mailing list